Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
close WB after clicking DISABLE MACROS
Hi all ,
Is there a way to close a workbook after the user clicks on the "Disable Macros" button on the security warning screen , instead of opening the workbook anyway. Thanks in advance Mario |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
close WB after clicking DISABLE MACROS
No because that requires macro code.
An alternative suggestion. Create a sheet with some text on saying that macros need to be enabled else the workbook is unusable. Hide all sheets except this one (in the VBIDE you can very hide them) Add some workbook_open event code that makes all other sheets visible and this one not visible (reverse it in the Workbook BeforeClose event and save it) If they disable macros, they will just get the warning screen, if they don't all is well. -- HTH Bob Phillips "Mario M" wrote in message ... Hi all , Is there a way to close a workbook after the user clicks on the "Disable Macros" button on the security warning screen , instead of opening the workbook anyway. Thanks in advance Mario |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding a Close Workspace option when right-clicking Excel in taskb | Setting up and Configuration of Excel | |||
Don't have all Excel windows close after clicking X on only one. | Excel Discussion (Misc queries) | |||
Disable Macros --> Close File | Setting up and Configuration of Excel | |||
Excel shoud not close all active books when clicking close button | Excel Discussion (Misc queries) | |||
Suppress the Disable Macros / Enable Macros Dialog | Excel Programming |