| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sheet NameTab Protection
Hi All
Can anyone advise how to protect the sheet name tab? I have protected the sheet but the Tab can still be edited. I want to stop users from changing names as these are used in VBA for navigation. Cheers Nigel |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Sheet NameTab Protection
Nigel
you cant unless you protect the workbook's structure however!.... have you considered using the sheets CODEnames for navigation? these are independent of the name that's visible to (and changeable by) the user. -- keepITcool | www.XLsupport.com | keepITcool chello nl | amsterdam Nigel wrote : Hi All Can anyone advise how to protect the sheet name tab? I have protected the sheet but the Tab can still be edited. I want to stop users from changing names as these are used in VBA for navigation. Cheers Nigel |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Sheet NameTab Protection
"Nigel" wrote in message ... Hi All Can anyone advise how to protect the sheet name tab? I have protected the sheet but the Tab can still be edited. I want to stop users from changing names as these are used in VBA for navigation. Cheers Nigel You have to protect the workbook to achieve this. /Fredrik |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Sheet NameTab Protection
Thanks for the replies. I will look into the CODE names
-- Cheers Nigel "Fredrik Wahlgren" wrote in message ... "Nigel" wrote in message ... Hi All Can anyone advise how to protect the sheet name tab? I have protected the sheet but the Tab can still be edited. I want to stop users from changing names as these are used in VBA for navigation. Cheers Nigel You have to protect the workbook to achieve this. /Fredrik |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Sheet NameTab Protection
Hi keepITcool,
What a great tip. I never knew that (there a lots of them!). I also like the fact having set the code name at design time, I can refer directly to the sheet without the Sheets(index) or Worksheets(index) approach. Users can change the tab and hence name as much as the like! -- Cheers Nigel "keepITcool" wrote in message .com... Nigel you cant unless you protect the workbook's structure however!.... have you considered using the sheets CODEnames for navigation? these are independent of the name that's visible to (and changeable by) the user. -- keepITcool | www.XLsupport.com | keepITcool chello nl | amsterdam Nigel wrote : Hi All Can anyone advise how to protect the sheet name tab? I have protected the sheet but the Tab can still be edited. I want to stop users from changing names as these are used in VBA for navigation. Cheers Nigel |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Data Protection Best Practice: AKA: Real Sheet Protection | Excel Discussion (Misc queries) | |||
| Excel Data Protection- AKA: Sheet/Macro Password Protection | Setting up and Configuration of Excel | |||
| sheet Protection | Excel Discussion (Misc queries) | |||
| sheet protection | Excel Worksheet Functions | |||
| Sheet protection error msg - Unrequested sheet activation | Excel Programming | |||
![Nigel[_7_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
