Worksheet Object Name

  • Thread starter Thread starter Andy
  • Start date Start date
A

Andy

On creating a new worksheet I can set the name of it (the
text shown on the tab) but I can't set the object name.
The properties of the sheet contain a object name property
shown as "(name)" which I cant grab hold of in VBA. Can
anyone help
 
The CodeName preoperty is read-only but can be changed through the VBE.

ThisWorkbook.VBProject.VBComponents. _
Item(ActiveSheet.CodeName).Properties("_CodeName").Value = "NewName"

For this to work, you need to set a reference to the VBE Extensibility
Library.
 
ThisWorkbook.VBProject.VBComponents. _
Item(ActiveSheet.CodeName).Properties("_CodeName").Value = "NewName"
Click to expand...

This can be shortened to

ThisWorkbook.VBProject.VBComponents(ActiveSheet.CodeName).Name = "NewName"

No reference to the Extensibility library is required.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Thanks for the correction, Chip!

--

Vasant


Chip Pearson said:
This can be shortened to

ThisWorkbook.VBProject.VBComponents(ActiveSheet.CodeName).Name = "NewName"

No reference to the Extensibility library is required.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
Click to expand...
 
Back
Top