Home |
Search |
Today's Posts |
#13
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I try to test it this evening
But if you use this there is no problem http://www.rondebruin.nl/mail/folder3/mail2.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm wrote in message ... I need the Workbook_BeforeClose event because it is used to save the workbook before closing it. But even without it, the Activate event is not called. Somehow the workbook main remains the active one, not the newly one using the class to create it. Nonethless the event doesnt really matter, the problem is that envelopeinvisible=false does not work properly. Did you try using it when the close event is called to close excel to see if it disposes the screen properly? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
difference application.quit & application.close | Excel Programming | |||
Application.GetOpenFilename vs Application.Dialogs(xlDialogsOpen) | Excel Programming | |||
Replace application.RTD property by Application.RTDServers collect | Excel Programming | |||
ActiveWorkbook.EnvelopeVisible = True | Excel Programming | |||
macro to close excel application other than application.quit | Excel Programming |