| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change hardcode to ....?
I do not wish to stop a user changing the tab name of a particular sheet,
but if they do, then I need to keep track of it. Say the tabname is "Temp" and the codename is Sheet1, as an example, how would I amend the following, please? If ws.Name = "Temp" Then Regards. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Change hardcode to ....?
Is ws.Codename = "Sheet1" Then
-- HTH Bob Phillips "Stuart" wrote in message ... I do not wish to stop a user changing the tab name of a particular sheet, but if they do, then I need to keep track of it. Say the tabname is "Temp" and the codename is Sheet1, as an example, how would I amend the following, please? If ws.Name = "Temp" Then Regards. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Change hardcode to ....?
Sorry, that is If not Is
-- HTH Bob Phillips "Stuart" wrote in message ... I do not wish to stop a user changing the tab name of a particular sheet, but if they do, then I need to keep track of it. Say the tabname is "Temp" and the codename is Sheet1, as an example, how would I amend the following, please? If ws.Name = "Temp" Then Regards. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Change hardcode to ....?
Got it, thanks.
Regards. "Bob Phillips" wrote in message ... Is ws.Codename = "Sheet1" Then -- HTH Bob Phillips "Stuart" wrote in message ... I do not wish to stop a user changing the tab name of a particular sheet, but if they do, then I need to keep track of it. Say the tabname is "Temp" and the codename is Sheet1, as an example, how would I amend the following, please? If ws.Name = "Temp" Then Regards. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Y Axis : Dynamically Hardcode Min/Max Values? | Charts and Charting in Excel | |||
| hardcode a column in a formula | Excel Worksheet Functions | |||
| Excel bar chart formatting of bars to change colors as data change | Excel Discussion (Misc queries) | |||
| Use date modified to change format & create filter to track change | Excel Worksheet Functions | |||
| Change Cell from Validated List Not Firing Worksheet Change Event | Excel Programming | |||
![Stuart[_21_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
