How to goto excel vba code when opening the macro opens Userform instead of Thisworkbook?

Question

I have written excel VBA code containing Userform and added code to show userform and hide Thisworkbook when the macro is opened. It shows userform during Start up. How to see the vba code, when userform is opened? Clicking Alt+F11 on Userform is not taking to VBA editor.

Possible duplicate of Open a workbook from VBA and disable Workbook_Open() code? — Comintern

Dave Dave · Accepted Answer · 2016-09-26T18:24:35

Press the Shift key and hold it down while you open the file. This will prevent the macro from firing (I'm assuming you have Workbook_open setting both Application.Visible = False and your userform's .Show method?)

How to goto excel vba code when opening the macro opens Userform instead of Thisworkbook?

1 Answers