Duplicate project.

fdmaxey

New Member
Joined
Mar 4, 2019
Messages
3
This one is really strange.
In one of my VBA routines I made the newbie error of an infinite loop. The only way I could stop it was to close the spreadsheet.

When I opened it again, my original project showed up twice in the project tree.

One of the duplicate projects works, but if I try to run the other one, it gives me the message that macros are disabled.

I tried to delete the duplicate project, but there doesn't seem to be a mechanism to do that.

Any suggestions?

TIA.
 

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.
Depends on the code involved ?
How it was closed?
Are they both the same size ?
Also, try renaming the one that doesn't work and make sure the other one still does work.....then I'd suggets deleting the bad one!
 
Upvote 0

Forum statistics

Threads
1,215,832
Messages
6,127,149
Members
449,365
Latest member
AlienSx

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