View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Scoops Scoops is offline
external usenet poster
 
Posts: 108
Default Force to enable macros


Denys wrote:
Good day everyone,

Is there such code that forces the user to enable the macros in order to
open a file?

In other words, if the user "disable" the macros, then the file cannot be
opened.

Thanks for your time...

Denys


Hi Denys.

No.

But perhaps you could use the Workbook_BeforeClose event handler to
"cripple" your workbook in some fashion (e.g. Protect all the cells or
make the sheets Very Hidden - apart from the one that says "If you
don't enable the macros, you don't get the worksheets!") and restore it
to health with Workbook_Open.

Regards

Steve