VBA code hanging in Excel after file delete

[apophysz]

Hi,
I tested a code in a file that disabled sheet delete and rename.
Now in every Excel file I create or open I can't rename any sheet, if I try Excel tries to open the initial file that had the code and tries to run a module procedure.
The code was:

In a sheet:

Please Login or Register  to view this content.

In a module:

Please Login or Register  to view this content.

Any idea how to get rid of this?
Thank you in advance!

[6StringJazzer]

The first sub disables the Delete and Rename controls at the application level. You should run the second Sub above to re-enable them. And then you should avoid running code that someone else wrote unless you know exactly what every line is doing.

[apophysz]

I ran the Worksheet_Deactivate code in a sub, the Delete option is reset but the Rename option still tries to open the file I tested the code in.

Update:
I just ran the reset code for the commandbar and all is back to normal.

Please Login or Register  to view this content.

[JBeaucaire]

Just a note, the correct way to quickly mark thread as solved is to select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

[apophysz]

Thank you, I corrected my thread.