Go to page button using 2 cells as reference

[r2fro]

go2page.xlsm


Hello there, Happy New Year to you!

I'm trying to achieve a "go to page button" using more than one cell as the reference.
My pages are named based on the contents of 2 cells and separated by a [comma space] - ", "

The Code I have at the moment is:

Please Login or Register  to view this content.

However, I really need the reference to include both "A1" & "B1".

Here is my "Rename Worksheet" Macro if it helps any.

Please Login or Register  to view this content.

Thanks for any help guys and gals

[Marc L]

Hi,

one button only to activate worksheet with active row columns A & B :

Please Login or Register  to view this content.

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

To activate:

Please Login or Register  to view this content.

[r2fro]

Thank you both very much!

Mark L, your suggestion of one button using the active row is outstanding and a massive improvement to my ideas on how to achieve this!

Great work!

SOLVED

Please Login or Register  to view this content.