How to view code if usrform is active

[hearthhrob4gals]

Hi,

I have a userform. On query close, i have written a code asking the user if they want to exit the form.

On clicking yes, the form unloads and the workbook gets auto saved and closed.

On clicking no, the form stays as it is. The issue is that i called this form from workbook_open and now there is no way to view the code. either the form stays as it is or the workbook gets closed.

is there anyway to view the source code or the sheets?

Regards,
Ali

 

[Trebor76]

Hi Ali,

Have a look at this article as to how to bypass the auto open macro from running.

Regards,

Robert

 

[hearthhrob4gals]

Hi Ali,

Have a look at this article as to how to bypass the auto open macro from running.

Regards,

Robert

Thanks,

I solved it by pressing together ctrl+Fn+S keys : )

 

[My Aswer Is This]

If you Open your UserForm like this you can see the code:

UserForm1.Show Modeless