Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
protection for tab names
Sheet protection does not protect tab names. How can I protect tab
names? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
protection for tab names
Yabi
Is there a reason for this. If it is to keep code running, there is a CodeName property that cannot be changed in the UI. You can refer to this and it is totally independent of the worksheet tab name Sheet1.Range("A1").Value for example. -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.nickhodge.co.uk blog: www.nickhodge.co.uk/blog/ FREE UK OFFICE USER GROUP MEETING, MS READING, 27th APRIL 2007 www.officeusergroup.co.uk "Yabi" wrote in message oups.com... Sheet protection does not protect tab names. How can I protect tab names? |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
protection for tab names
On Apr 16, 9:50 am, "Nick Hodge"
wrote: Yabi Is there a reason for this. If it is to keep code running, there is a CodeName property that cannot be changed in the UI. You can refer to this and it is totally independent of the worksheet tab name Sheet1.Range("A1").Value for example. -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England web:www.nickhodge.co.uk blog:www.nickhodge.co.uk/blog/ FREE UK OFFICE USER GROUP MEETING, MS READING, 27th APRIL 2007www.officeusergroup.co.uk "Yabi" wrote in message oups.com... Sheet protection does not protect tab names. How can I protect tab names? I have links in sheet 1 to 15 sheets from sheet 2 to 16. if I change sheets name, then the link will not work. I want to protect sheets from changing. |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
protection for tab names
Protect the workbook under ToolsProtection.
Gord Dibben MS Excel MVP On 16 Apr 2007 01:30:48 -0700, "Yabi" wrote: On Apr 16, 9:50 am, "Nick Hodge" wrote: Yabi Is there a reason for this. If it is to keep code running, there is a CodeName property that cannot be changed in the UI. You can refer to this and it is totally independent of the worksheet tab name Sheet1.Range("A1").Value for example. -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England web:www.nickhodge.co.uk blog:www.nickhodge.co.uk/blog/ FREE UK OFFICE USER GROUP MEETING, MS READING, 27th APRIL 2007www.officeusergroup.co.uk "Yabi" wrote in message oups.com... Sheet protection does not protect tab names. How can I protect tab names? I have links in sheet 1 to 15 sheets from sheet 2 to 16. if I change sheets name, then the link will not work. I want to protect sheets from changing. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting and matching rows of names with Socials with master list and eliminating the extra names | Excel Worksheet Functions | |||
Cell Protection vs. Worksheet Protection | Excel Discussion (Misc queries) | |||
Can I check names in one list agains names in another in excel? | Excel Discussion (Misc queries) | |||
Worksheet protection is gone and only wokbook protection can be se | Excel Discussion (Misc queries) | |||
sorting names alphabetically when names may start with numbers | Excel Discussion (Misc queries) |