force users to enable the macro

[irresistible007]

i was just looking for the way to force users to enable the macro when i found solution here... Since i am not a champ i am quite confused at the code... cuz if the user disable macros... how can this code still run to hide all sheets except one?

 

[DominicB]

Good afternoon irresistible007

There is no way to force users to accept the macros when opening a file. The code provided works like this.

The file is saved with all tabs (except one) hidden.
If the user doesn't accept macros all he sees is one tab (usually with a message telling him why he can't see the full worksheet).
If the user accepts macros then the code unhides all the other sheets.
When the file is saved again all tabs are hidden again and the file is saved.

The file I am suggesting in answer to your other post (http://www.mrexcel.com/board2/viewtopic.php?t=237953) uses this technique, except it's already done for you.

HTH

DominicB

 

[irresistible007]

ahan... i got it... thats a huge trick (for me atleast)

 

[copleyr]

this is very helpful. is there anyway to do this in powerpoint?