Update vba project

drom

Active Member
Joined
Mar 20, 2005
Messages
495
Office Version
  1. 2019
  2. 2016
  3. 2013
  4. 2011
  5. 2010
  6. 2007
Hi and Thanks in advance

Some times when I am working with my macros, saving and/or creating workbooks

once I have closed the created workbooks, when I go to VBA, I see different Workbooks on the VBA projects.

Some time as well if I close everithing and I open again the WorkBook contaning the macros I see 2 times in VBA the same workBook name.


How can Update VBA to see only the workbooks that are open, and only one time??


or even If I don't have anything open on excel if I go to vba, isee one workbook on the VBA project.

What's going on ??



I can even run using F8, the macro, SO RARE

is there any way of update the VBA explores??
 
Last edited:

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

Forum statistics

Threads
1,196,053
Messages
6,013,118
Members
441,749
Latest member
batel19

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