Enable Macro Security Via Macro Or automatically

Closed
aptpsbwmraj
Posts
9
Registration date
Sunday July 14, 2013
Status
Member
Last seen
August 21, 2015
- Jul 30, 2015 at 08:32 AM
TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 27, 2022
- Aug 24, 2015 at 10:43 AM
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

TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 27, 2022
513
Jul 30, 2015 at 11:26 AM
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
0
aptpsbwmraj
Posts
9
Registration date
Sunday July 14, 2013
Status
Member
Last seen
August 21, 2015

Aug 21, 2015 at 08:28 AM
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
0
TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 27, 2022
513
Aug 24, 2015 at 10:43 AM
Hi Aptpsbwmraj,

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

Best regards,
Trowa
0