Open a Wb without raising the Wb_Open event. 
Author Message
 Open a Wb without raising the Wb_Open event.

Hello All.

Does anybody know how to open a Wb without raising
the Workbook_Open event, like it was in XL5 ?

In other words, how to deactivate the auto macros in
XL2K ?

I tried Application.EnableEvents = False
with no success.

Thanks.
Patrick Penet



Wed, 18 Jun 1902 08:00:00 GMT  
 Open a Wb without raising the Wb_Open event.
Do you mean how to do it in code or how to do it manually?  In Excel97,
holding down the shift key while opening the file, disables the
Auto_Open macros - for what it's worth?
Perhaps misunderstood your request?


Quote:
> Hello All.

> Does anybody know how to open a Wb without raising
> the Workbook_Open event, like it was in XL5 ?

> In other words, how to deactivate the auto macros in
> XL2K ?

> I tried Application.EnableEvents = False
> with no success.

> Thanks.
> Patrick Penet

--
Ctrl-Alt-Dlt-Hlp ?)?

Sent via Deja.com http://www.deja.com/
Before you buy.



Wed, 18 Jun 1902 08:00:00 GMT  
 Open a Wb without raising the Wb_Open event.
Application.EnableEvents=False
 is the only way to do it.

Since workbooks_open is an event and you have disabled events
Application-wide, then this should work.

A workaround would be a boolean variable which the event checks at the top
and exits for a specific setting - but I have never had a problem with the
first approach.

Regards,
Tom Ogilvy
MVP Excel


Quote:
> Hello All.

> Does anybody know how to open a Wb without raising
> the Workbook_Open event, like it was in XL5 ?

> In other words, how to deactivate the auto macros in
> XL2K ?

> I tried Application.EnableEvents = False
> with no success.

> Thanks.
> Patrick Penet



Wed, 18 Jun 1902 08:00:00 GMT  
 Open a Wb without raising the Wb_Open event.

Patrick
Here is the reason:

http://support.microsoft.com/support/kb/articles/Q184/0/00.ASP
XL97: Controlling Events in an Automation Server

Posted by
-Mike Dimitroff
in a thread a bit below this one.

Regards,
Tom Ogilvy
MVP Excel


Quote:
> Application.EnableEvents=False
>  is the only way to do it.

> Since workbooks_open is an event and you have disabled events
> Application-wide, then this should work.

> A workaround would be a boolean variable which the event checks at the top
> and exits for a specific setting - but I have never had a problem with the
> first approach.

> Regards,
> Tom Ogilvy
> MVP Excel



> > Hello All.

> > Does anybody know how to open a Wb without raising
> > the Workbook_Open event, like it was in XL5 ?

> > In other words, how to deactivate the auto macros in
> > XL2K ?

> > I tried Application.EnableEvents = False
> > with no success.

> > Thanks.
> > Patrick Penet



Wed, 18 Jun 1902 08:00:00 GMT  
 
 [ 4 post ] 

 Relevant Pages 

1. Macro to Copy 2 Wb Ranges into 3rd Wb.

2. Copy Sheet to another WB without activating it?

3. Raising a custom event - problems

4. Raise custom events from Excel?

5. Raising Events on a parent application

6. Which WB Event/processing might be best?

7. Bug: MouseMove event is not raised when a button is pressed

8. Raising Form Event from class module

9. Raise error for the form's error event

10. Raised/Sunken object on mouse events...


 
Powered by phpBB® Forum Software © phpBB Group