View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kevin Kevin is offline
external usenet poster
 
Posts: 134
Default problems closing workbook

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