Select Sheet Code Name

[Marhier]

Good afternoon, I hope you're all well.
I'm having an issue with a bit of VBA, where all it's doing is selecting another worksheet.

Typically, I would have used:

Sub CallSheet()
Sheets("Example").Select
End Sub

As users sometimes change the worksheet's name, I wanted to use the sheet's codename - Example, I've called it "Page"
Using the code:

Sub CallSheet()
Page.Select
End Sub

When I do this, it's giving me a "Reference is Invalid" error.

Can someone let me know what I'm doing wrong here?

Much appreciated.
Thank you.
Regards
Marhier

 

[Fluff]

Is the code in the same workbook as the sheet?

 

[Marc L]

Hello !​

​

Is the worksheet located in the workbook containing this VBA procedure ?​

 

[Marhier]

Hi Fluff & Marc L
The code is located in a module called ButtonFunctions

 

[RoryA]

The question they were asking is whether that module is in the same workbook as the sheet you are trying to select? If not, you can't use the codename (at least not without setting a reference).

 

[Marhier]

Apologies.
Yes, it's in the same document

 

[Fluff]

And if you look at the project explorer window for that workbook you have something like Page (Example)

 

[RoryA]

The code should be fine then. Do you have any other event code, like Worksheet_Activate? Or hyperlinks assigned to the buttons?

 

[Marhier]

The buttons had a hyperlink on them.
This has solved my problem, lol.

Thanks mate.
I'd have never of realised that without your help, as I knew the code I was typing was right!

Thanks again
Regards
Marhier