LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #13   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,123
Default help with Application.EnvelopeVisible

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
difference application.quit & application.close Pierre via OfficeKB.com[_2_] Excel Programming 4 November 8th 05 07:55 PM
Application.GetOpenFilename vs Application.Dialogs(xlDialogsOpen) Paul Martin Excel Programming 5 August 5th 05 04:44 PM
Replace application.RTD property by Application.RTDServers collect John.Greenan Excel Programming 1 July 7th 05 02:05 PM
ActiveWorkbook.EnvelopeVisible = True DFox Excel Programming 3 October 7th 04 07:51 PM
macro to close excel application other than application.quit mary Excel Programming 1 September 14th 04 03:43 PM


All times are GMT +1. The time now is 09:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"