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.

excel stop form from loading when workbook opens

To do it in Excel, here is the answer:

a) From Excel, Click on "Open" under "File".

excel excel stop form from loading when workbook opens

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.

excel excel excel stop form from loading when workbook opens

c) The file is opened without the form being loaded as shown below.

excel excel excel excel stop form from loading when workbook opens

 

You can find similar Excel Questions and Answer hereunder

1) How can I save a WorkSheet as a new WorkBook using VBA?

2) Vba code to password protect workbook in Excel

3) How can I extract file name from a full path including folder path and file name?

4) How can I hide a specific Shape in my WorkSheet?

5) Vlookup to return max value from multiple hits in Excel

6) I want to automatically run a procedure whenever I close my WorkBook so that it is in a known state - how can I achieve that?

7) I have to retrieve data from a specific column in a Table. In Excel, how can I do that?

8) How can I remove hyperlinks from a range of cells?

9) I want to automatically run an initialization procedure whenever I open my WorkBook so that it is ready for use - how can I achieve that?

10) How can I clear all formats (formats alone not data) from a range of cells?

11) I have data arranged in rows of information. Is there any way I can enter new data through a form instead of entering it directly in SpreadSheet?

12) How can I quickly navigate to a frequently used field in a voluminous worbook?

13) Calling a macro from another workbook in Excel

14) I have WorkBook with sensitive confidential information - how do I encrypt / protect my file so that access to file contents is restricted?

15) Is there a way to create an visually impactful report with stop lights indicating automatically if Target is met?