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 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Aug 24, 2015 at 10:43 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Aug 24, 2015 at 10:43 AM
Related:
- Enable Macro Security Via Macro Or automatically
- Spell number in excel without macro - Guide
- Automatically run a macro when opening a worksheet - Guide
- Macro excel download - Download - Spreadsheets
- Fnaf security breach free download - Download - Horror
- How to enable volte in vi - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Jul 30, 2015 at 11:26 AM
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
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
Aug 21, 2015 at 08:28 AM
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
Aug 24, 2015 at 10:43 AM
Well, what are your thoughts on the workaround explained in my previous post?
Best regards,
Trowa