Cannot Change Sheet Name in VB Editor

[nryan]

Hello,

So, I've highlighted my worksheet "Sheet2 (Instructions)" in the VB editor I pressed F4 to bring up the properties toolbar and I was able to changed the VB name of my worksheet to "Instructions". Therefore, in the VB editor, the worksheet is now called "Instructions (Instructions)". I did this so I can refer to the worksheet in the VB code as Instructions.Yada.Yada.Yada... instead of Worksheets("Instructions").Yada.Yada.Yada.

My problem is when I try to change the name of "Sheet3" to "ProbeSpec" using the same method I get an error "Invalid Property Value (380)". I tried changing the name of that sheet to anything I could think of (ABC, 123, Sheet, etc.) and I still get the same error. Any thoughts?

Thank you.

 

[mole999]

Worksheets("Instructions") or sheets("Instructions") is far easier to understand written in code that Instructions (Instructions). As you have found changing it round has started causing issues

 

[nryan]

That's a fair point.

Thanks Mole999.