GoTo Worksheet based on which button clicked

[Paul Martin]

Hi All

I would like to write one routine that handles navigation to different
worksheets based on the name assigned to a button.

- I have a number of navigation buttons on a worksheet (the buttons
are from the Forms toolbar)
- Each button will navigate to a different worksheet
- I have given each button a different name, which is the same name as
the worksheet that it goes to
- For example, the button that goes to Worksheets("TestSheet") has the
name "TestSheet"
- The worksheet with the buttons is protected (so the buttons cannot
be selected)

What I don't know, is how to capture Shapes("TestSheet").Name when it
is clicked. I'd prefer not to have a whole case statement, if
possible.

All suggestions appreciated.

Paul Martin
Melbourne, Australia

 

[Bob Phillips]

Hi Paul,

Use

MsgBox Application.Caller


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Paul Martin]

Thanks, Bob. Brilliant.

Paul

Hi Paul,

Use

MsgBox Application.Caller


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)