I need to rename a worksheet using the VBA Project name as the reference.
The following renames the VBA project name of the sheet, which I don't want.
ThisWorkbook.VBProject.VBComponents("Sheet4").Name = "Data"
I want the VBA project name to remain as "Sheet4", but the sheet name to change to "Data"
Would someone please offer some advice.
Regards
Yoepy
Bookmarks