force users to enable the macro

irresistible007

Board Regular
Joined
Nov 24, 2005
Messages
173
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?
 

Some videos you may like

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

DominicB

Well-known Member
Joined
Oct 3, 2005
Messages
1,569
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
 

copleyr

Active Member
Joined
Aug 24, 2009
Messages
381
this is very helpful. is there anyway to do this in powerpoint?
 

Watch MrExcel Video

Forum statistics

Threads
1,114,041
Messages
5,545,685
Members
410,697
Latest member
srishtijain0708
Top