Go to page button using 2 cells as reference

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

Hi,

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

Please Login or Register  to view this content.

Maybe:

Please Login or Register  to view this content.

To activate:

Please Login or Register  to view this content.

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.