Windows Opening in Visual Basic Editor

devilishblueyes

New Member
Joined
Oct 18, 2007
Messages
18
I have installed several Excel add-ins that I created on my computer. And whenever I open Excel Visual Basic Editor many of the Code Windows that I have closed before exiting the VBA Editor keep popping up each time I open the VBA Editor. It also happens with some of the forms from those Add-Ins. For example, I can close every form window and every code window before exiting the VBA Editor in Excel and EVERY time I open the VBA Editor with Alt + F11 all of those same windows are shown as open again. It's frustrating and I can't find anything on the internet about the problem or how to fix it. Anyone know what the heck is going on? I close them by clicking the X in the top right corner of the window.

Is there some other way you're supposed to close them?

Could it be how I exit the VBA Editor (X in top right corner)?

Or does some setting need in the VBA program need to be changed?

I'm getting tired of closing like 12 windows each time I open the VBA Editor so that I can program.

Thanks!
 

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.
You don't need to close them. You only have to navigate to the module you want to edit inside one of your workbooks using the Project Explorer. It gets turned under the VIEW ribbon menu "Project Explorer"

It's normal to have those windows open each time you start the VBA. I guess you could add a password to your addin VBA project. That way none of the modules or forms will display in those addins.

Jeff
 
Upvote 0

Forum statistics

Threads
1,224,823
Messages
6,181,180
Members
453,021
Latest member
Justyna P

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top