Force Enable Macros

[wtsabo]

I also am trying to force users to enable macros, but the VBA code that I found searching Google conflicts with my cases for each worksheet. I thought a better alternative might be initially hiding (using VeryHidden) all the worksheets except my menu and then forcing the user to enter the respective worksheet name and password that will subsequently show.

Does anyone have any ideas how I can do the prompt a user to enter the worksheet?

Thank you!

 

[dmt32]

I also am trying to force users to enable macros, but the VBA code that I found searching Google conflicts with my cases for each worksheet. I thought a better alternative might be initially hiding (using VeryHidden) all the worksheets except my menu and then forcing the user to enter the respective worksheet name and password that will subsequently show.

Does anyone have any ideas how I can do the prompt a user to enter the worksheet?

Thank you!

The idea only really works if user enables macros - which of course, the may not!

There are plenty of examples on web in how you could go about this - here is one: VBA Express : Excel - Force users to enable macros in a workbook

Hope helpful

Dave

 

[wtsabo]

I tried using the force enable marco you are referring to, but for some reason it conflicts with assigning each worksheet with a password. Everytime I tried to closed the workbook, the macro thought it was individually closing each tab resulting in a failed password entry and an already hidden homepage.