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?
 

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

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?
 

Forum statistics

Threads
1,141,666
Messages
5,707,715
Members
421,525
Latest member
carian1980

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top