Hi
I want to disable the worsheet rename functionality. I have already disabled the "rename" functionlaity in the "Edit" menu and shortcut menu. but when double click on the sheetname tab, still I can rename the sheet.
How can I prevent the renaming by double click on sheet name tab?
Thanks
Protect the Workbook (not the worksheet). Go to Tools > Protection > Protect Workbook. Make sure 'Structures' is checked, set a password and confirm the password.
Now you won't be able to add/modify/delete sheets or change workbook settings, but the worksheet cells will remain unprotected. (Unless you protect the Worksheet(s) too.)
When i protect the workbook than i can't add or delete a workbook. I need to add and delete a worksheet. What i want is that the worksheetname not can changed
Administrative Note:Originally Posted by glda19
Welcome to the forum.
We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.
Please see Forum Rule #4 about hijacking and start a new thread for your query.
If you are not familiar with how to start a new thread see the FAQ: How to start a new thread
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks