Disable form from opening @ workbook opening

[rob_h]

I have created a workbook such that when a user opens it they are asked to enter job information before saving as a copy.

Now I want to have another command button that will open the master workbook, update particular ranges, then save and close. However, it would be ideal if the user didn't need to exit the job information form when this happens.

What statement can I write that will tell that form to either not appear, or cancel itself without user interaction?

Thanks for any and all ideas.

[xlnitwit]

Hi,

If the form is opened by the Workbook_Open event, you can disable that using

Please Login or Register  to view this content.

before opening the workbook in code; then reset the value to True after opening it. If you are using an Auto_Open routine, you do not need to do anything as that will not run when you open a workbook in code.

[rob_h]

Thank you so much. This sounds exactly like what I want.

I'll let everyone know when I get it checked.

[rob_h]

After a little effort this works exactly as I want. The first attempt didn't work only because I only added the False statement to see if it would bypass the form, and the form still appeared.

Even if there is no code between the two statements, the False & True lines must both be there.

Thank You