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
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.
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
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
486Well, what are your thoughts on the workaround explained in my previous post?
Best regards,
Trowa