MACRO ENABLE/DISABLE

[mrbeanyuk]

Hi there. Yet another question.......

I know this is a longshot, but is there a way that when a spreadsheet is opened, when you click on Disable Macros it kicks you out yet when you click enable it will let you in?

Thanks!

 

[erik.van.geit]

Hi again (isn't it ?)

the method which is mostly used is to hide all relevant sheets by macro
only activating macros will unhide them

see for example
http://www.danielklann.com/excel/force_macros_to_be_enabled.htm

there are other methods if needed ...

kind regards,
Erik