Hiding Worksheet while VBA App runs (2003)

Topic

New Reply

I have a project that I have been working on this week and it is done except for some minor tweaks. It is a user survey that captures results into a worksheet. I start it with a button on the worksheet, and the worksheet is visible while the VBA App is running. So here are my questions:

1) How can I hide Excel while the VBA App runs?
2) Can I start the app when the excel file is opened?
2a) If the VBA app starts when this file is opened, how do I ever get at the worksheet?

Thanks,

Andy

Reply | Quote

Replies

You can set Application.Visible = False in the UserForm_Initialize procedure, and if you wish Application.Visible = True in the On Click procedure of the Close button.

You can call OpenSurveyForm in the Workbook_Open event procedure (in ThisWorkbook).
If you hold down Shift while opening the workbook, the Workbook_Open code will not run.

See attached version.

Reply | Quote

N.B. the caption of the first command button on the userform should be Submit instead of Sumbit.

Reply | Quote

Jeez, thanks for the spelling catch and for the tip.

Andy

Reply | Quote