Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How can force enable macros to be able to open my workbook? | Excel Discussion (Misc queries) | |||
Force Enable Macros | Excel Programming | |||
Force Enable Macros | Excel Programming | |||
Force Enable Macros | Excel Programming | |||
Force Enable Macros | Excel Programming |