| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet codename
On previously asking for help on renaming the object name
of a worksheet I got the responce(s) below but can't get either to work, I know the codename property is correct as I can view the object name in a message box, I just can't rename it. Can anyone offer me some further help. Ta Andy (This one requires Extensibility library ref) ThisWorkbook.VBProject.VBComponents.Item (ActiveSheet.CodeName).Properties("_CodeName").Val ue = "NewName" or ThisWorkbook.VBProject.VBComponents (ActiveSheet.CodeName).Name = "NewName" |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| string to codename | Excel Discussion (Misc queries) | |||
| Referencing worksheet CODENAME in a chart object. | Excel Discussion (Misc queries) | |||
| How do I determine the Acrobat Distiller codename? | Excel Programming | |||
| Attaching a JET database to an Excel Worksheet OR storing large binary data in a worksheet | Excel Programming | |||
| Codename equivalent for Series | Excel Programming | |||
Threaded Mode
