MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Renaming a worksheet


Posted by Raishon on May 17, 2001 9:44 AM

Is there a visual basic code to prevent a user from renaming a worksheet tab on a locked spreadsheet?


Posted by Chris Wheeler on May 17, 2001 10:06 AM

Go To The Tools Menu.
Select Protection.
Protect The Sheet.

Enter A Password.

The User Of The File Will Then Need A Password To Change The Name Of The Worksheet.

Posted by Raishon on May 17, 2001 10:17 AM

I did that. That protects everything except the name of the worksheet.

Posted by Chris Wheeler on May 17, 2001 10:28 AM

Raishon,

When I Protect The Workbook From This Menu It Won't Allow Me To Change The Name Of My Worksheet.

I Have Just Tried This A Few Times And It Worked Well.

Posted by Raishon on May 17, 2001 10:33 AM


It doesn't work for me. I'm talking about the tab names at the bottom of the worksheet. In my workbook I have four worksheets and I have protected each sheet individually and you can still double click on the tab name at the bottom of the sheet and rename the tab.

Posted by Chris Wheeler on May 17, 2001 10:43 AM

If You Protect The Workbook As A Whole Not The Individual Sheets You Will Not Be Able To Rename The Tabs At The Bottom. When I Right Click The Tabs At The Bottom Of My Sheet The Rename Option Is Greyed Out.

Try Unprotecting The Sheets & Protecting The Entire Workbook.

Posted by Raishon on May 17, 2001 11:09 AM

Posted by Raishon on May 17, 2001 11:10 AM

Try Unprotecting The Sheets & Protecting The Entire Workbook.

THANKS... That worked ;0)