Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sheet properties
In a sheets property table there are two fields: Name and (Name). Can anybody
tell me the difference? Or direct me to the help topic describing this? I can control the Name property (ActiveSheet.Name = "My Sheet"), but how can I change the (Name)? Thanks The Doctor |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sheet properties
On Mon, 23 Aug 2004 03:59:02 -0700, "Dr.Schwartz"
wrote: In a sheets property table there are two fields: Name and (Name). Can anybody tell me the difference? Or direct me to the help topic describing this? I can control the Name property (ActiveSheet.Name = "My Sheet"), but how can I change the (Name)? Thanks The Doctor Not sure if you're trying to do this programatically, but can't you just go to the Properties window and change it there? Rgds __ Richard Buttrey Grappenhall, Cheshire, UK __________________________ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sheet properties
No, I want to control it from my code.
"Richard Buttrey" wrote: On Mon, 23 Aug 2004 03:59:02 -0700, "Dr.Schwartz" wrote: In a sheets property table there are two fields: Name and (Name). Can anybody tell me the difference? Or direct me to the help topic describing this? I can control the Name property (ActiveSheet.Name = "My Sheet"), but how can I change the (Name)? Thanks The Doctor Not sure if you're trying to do this programatically, but can't you just go to the Properties window and change it there? Rgds __ Richard Buttrey Grappenhall, Cheshire, UK __________________________ |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sheet properties
Doc,
The property is the codename and is a good way of addressing a sheet in VBA where the user might change the worksheet name. This code shows how to change it in VBA With ActiveSheet .Parent.VBProject.VBComponents(.CodeName) _ .Properties("_CodeName") = "somevalue" End With But why bother, because it is hidden from users, you don't need to. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Dr.Schwartz" wrote in message ... In a sheets property table there are two fields: Name and (Name). Can anybody tell me the difference? Or direct me to the help topic describing this? I can control the Name property (ActiveSheet.Name = "My Sheet"), but how can I change the (Name)? Thanks The Doctor |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sheet properties Name and (Name) | Excel Discussion (Misc queries) | |||
Sheet tab properties | Excel Discussion (Misc queries) | |||
Print>Properties>Layout>Pages per sheet: this function/property . | Excel Discussion (Misc queries) | |||
properties of object on another sheet | Excel Programming | |||
Active X not updating properties on Excel Sheet | Excel Programming |