Hi Experts,
By chance I have opened a sheet with some macro and after that 'right click' is not working in any of the excel sheets (even newly created ones) in sheet names tab.
i.e., I can't delete/rename/insert etc in any sheet by rightclicking the sheet name.
Even the Edit->'delete sheet' is disabled. However, Insert->worksheet is enabled.
Please advise how to make the right click enabled. (excel version 2003)
Thanks in advance..
Perhaps you should delete the macro? Editing the sheet name should still be possible if you double-click it.
please share your sheet with macro.
Wow.. Thats really simple way to 'Rename'Thank you..
My bad luck is that I am unable to find which sheet caused the problem. I checked all possible sheets which I opened today. But unfortunately they were all created long back and macros are password protected. Nobody knows the password now..
Last edited by soffia; 08-08-2014 at 09:26 AM.
Hy soffia,
Maybe if you could upload the file we could help you more.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks