Excel close on Userform Termination

[sustinMyers]

Hi, I created a utility for data retrieval/input and it is meant for customer use, therefore I designed it to only show a userform when the workbook is opened, and close the excel application when the userform is terminated. However, this makes it so I now cannot access the Visual Basic editor. I have tried opening another workbook, but my Utility does not show up in the project explorer.

Is there anyway I can access the VBA editor for this workbook?

Thank you

 

[sykes]

Hi, and welcome to Mr. Excel!
Can you temporarily disable all code running, by setting the macro security to "high" or stopping all code running, then open the problem workbook that way?

 

[jkpieterse]

See: https://jkp-ads.com/Articles/preventopenevent.asp

 

[sustinMyers]

This worked perfectly. Thank you!!