Rename Sheet using VBA Project name as a reference

[Yoepy]

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

[JLGWhiz]

If you use

Please Login or Register  to view this content.

Then Excel will automatically change the sheet name in the Project pane of the editor. I am not sure you can make that change in reverse fashion by changing the sheet tab name in the project pane without changing it in the Excel window.

[Yoepy]

Sorry JLGWhiz, that renames a sheet called "Sheet4".
There is no sheet called "Sheet4".
I'm wanting to rename the sheet which according to the Microsoft Excel Objects in the VBA Project window is called Sheet4(somethingelse) to Sheet4(Data), using the Excel object as the reference.

I don't want the Properties name to change - just the sheet name shown on the worksheet tab.

Regards

Yoepy

[jindon]

Please Login or Register  to view this content.

Or simply

Please Login or Register  to view this content.

[Yoepy]

Thanks jindon. Exactly what I needed.

[JLGWhiz]

Just for clarity:

Please Login or Register  to view this content.

is the sheet tab name

Please Login or Register  to view this content.

is the Excel code name of a sheet and could have a different tab name

Please Login or Register  to view this content.

is the fourth sheet from left to right and could have both code name and tab name different.

[Yoepy]

Thank you JLGWhiz, that's a simple but important explanation.