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

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

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