Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm not certain, but it appears I've crated a conflict between my Workbook-level code and the module-level code. When I close the workbook using the "X", the "Enable Macros" / "Disable Macros" window displays...after 10 seconds; the duration of the timer. What can I do to eliminate the Macros window
Thanks Kevi The following code exists in Module1 Sub Auto_Open( Application.OnTime Now + TimeValue("00:00:10"), "Close_Workbook End Su Sub Close_Workbook( Application.DisplayAlerts = Fals Application.Qui End Su The following code exists in ThisWorkbook Sub Workbook_BeforeClose(Cancel As Boolean ThisWorkbook.Saved = Tru ThisWorkbook.Clos End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Closing a workbook | Excel Discussion (Misc queries) | |||
Help with closing down a workbook?? | Excel Worksheet Functions | |||
prohibit closing a workbook | Excel Discussion (Misc queries) | |||
Closing Workbook without Saving | Excel Programming | |||
closing workbook | Excel Programming |