Macro to Always Enable Macros

[Tennisball]

Is there a Macro that ensures that macros are always enabled, everytime the workbook is opened? I am looking for something that I can apply to my workbooks that ensures that the macros I have written for my passwords are always enabled.

 

[snowblizz]

No.

The fundamental idea of macro security is that a macro cannot run unless you allow it.

There are some ways to "force" people to turn on macros, basically making the workbook useless unless macros are enabled.

 

[Tennisball]

Ok thanks that is really good to know. So how do I write a macro that makes the work book useless unless macros are enabled. Like is there a way to write a macro that makes certain sheets appear from veryhidden only when the macro is enabled?

 

[bobsan42]

well if the macros are enabled - put the code to unhide the
and for the workbook - Beforeclose event - hide them again and save
so when opened next with disabled macros the sheets stay hidden.
of course if not properly closed - they will stay visible

Hope this will work

 

[snowblizz]

Ok thanks that is really good to know. So how do I write a macro that makes the work book useless unless macros are enabled. Like is there a way to write a macro that makes certain sheets appear from veryhidden only when the macro is enabled?

Essentially how it's done, IIRC, is that you have all sheets "veryhidden" except a empty "info" sheet which would contain a note that macros are required for the workbook.

In the Workbook.open you place code that unhides all the sheets and hides the info sheet. In Workbook_BeforeClose you place code that unhides the info sheet and hides all the other sheets.

This is by no means fully secured, as Excel can be broken open relatively easily. And there is bound to be problems e.g. if the workbook crashes and is restored it is probably in an "open" state. So if we are talkign stuff that really really need to be confidential then Excel isn't quite the place.