stop form from loading when workbook opens in Excel
Q141. I have a WorkBook that loads a form automatically when it is opened. In Excel, how can I suppress the form from loading on file open when required?
For example, in my WorkBook, "Estimate - Interior Work" form loads automatically when I open the WorkBook. Sometimes, I would like to prevent this form load when file is opened.
To do it in Excel, here is the answer:
a) From Excel, Click on "Open" under "File".
b) In the File Open Dialog Box that pops up, navigate to the folder and select the file of interest. Click OK while holding "Shift" Key.
c) The file is opened without the form being loaded as shown below.