Enable Macro Security Via Macro Or automatically

[Closed]
Report
Posts
9
Registration date
Sunday July 14, 2013
Status
Member
Last seen
August 21, 2015
-
Posts
2818
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 18, 2021
-
Hello,

Dear Friends i m not good in english so sorry in advance for bad english. but i need to enable macro automatically when worksheet open in excel . but it is not possible without enble macro security and i can not go every where in my companies offices for enable security'
so please if any one of you make it possible for me help me pleaseeeeeeeeeeeeeee
thanks in advance

1 reply

Posts
2818
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 18, 2021
486
Hi Aptpsbwmraj,

The security is there to prevent harmful macro's to do ... uhm ... harm. If these harmful macro could adjust the security, then what is the purpose of security in the first place?

A workaround would be to create a sheet, which explains how to enable macro's. Hide all other sheets and just display the explanation sheet. You could then write a code that will hide the explanation sheet and unhide all the others.

So when macro's are disabled, only the explanation sheet will show. If they then enable macro's and restart the file, then your macro will kick and show the file as intended.

Best regards,
Trowa
Posts
9
Registration date
Sunday July 14, 2013
Status
Member
Last seen
August 21, 2015

TrowaD thenks for reply

ur right but how could i run excel programme on pc in all oavr country because my office branch are all over country.
is there any way to do it plzzzzz
Posts
2818
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 18, 2021
486
Hi Aptpsbwmraj,

Well, what are your thoughts on the workaround explained in my previous post?

Best regards,
Trowa