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:
In a module:
Please Login or Register to view this content.
Any idea how to get rid of this?Please Login or Register to view this content.
Thank you in advance!
Last edited by apophysz; 06-08-2015 at 02:07 AM.
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.
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.
Last edited by apophysz; 06-08-2015 at 12:54 AM.
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.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Thank you, I corrected my thread.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks