Jerry, Two ways, if adopted can help protect the sheet the way you want to:
1) Code should be used to hide, Renaming sheet option on the worksheet menu bar i.e. going to Format ---> Sheets-----> Rename 2) On worksheet_deactivate event can be used to rename the sheet back to the same name it was before renaming it The first code can exist in the Auto_open event, while a similar code to reverse the step performed in step 1 should be included in the workbookclose event I am not very strong with the coding of the commandbars, but i beleive members will post something with respect to this idea.... I hope this will help, these are some of the solutions i thought of while working on your problem, i hope they work good Harry On Jun 5, 8:30 am, Jerry <centau...@live.co.uk> wrote: > The subject says it all. I want to prevent the user from renaming a > couple of worksheets in a workbook but I do not want to prevent the > user from modifying the data on the worksheet. -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
