Load a form without running form initialize event??

[Jooky68]

Is there a way to open up a form without the form load (or initialize ) event procedure activating? I want to skip it depending on how the user is activating the form. Thanks in advance.

 

[mmtraining]

Put the code into another procedure and stick an if/then/else into the autorun procedure. That should test whether a variable has got a certain value, for example.

All the best,

Carol, Berlin

 

[xlbo]

depending on how it is being invoked, it could be simply a case of using
Application.enableevents = false
depending on a condition or, testing a boolean variable:

Public FormOpenFromButton as boolean

In the form initialise event, use

IF FormOpenFromButton = FALSE then exit sub
Other code in initialise event goes here. This will mean the event will fire but if the boolean value is FALSE, it will skip all the code in there


Rgds, Geoff
Si hoc legere scis, nimis eruditionis habes
Want the best answers to your questions ? - then read me baby one more time - faq222-2244