GoTo Worksheet based on which button clicked
 

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

GoTo Worksheet based on which button clicked
 

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" wrote in message
om...
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

GoTo Worksheet based on which button clicked
 

Thanks, Bob. Brilliant.

Paul



"Bob Phillips" wrote in message ...
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" wrote in message
om...
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