Hi all...

Windows XP
Excel 2000 (9)

I have a set of 10 control buttons on a worksheet, named "Button 1" thru "Button 10" all with different text (which happens to be the sheet name of various sheets in the workbook)

I assign the same macro to them all.

I want to know WHICH button called the macro, and then goto a different worksheet depending on the .TEXT of the button that ran the macro

I can do
myString = [Button 1].Text

if I know its Button 1 that ran the macro.

I am hoping there is something like

myString = ActiveButton.Text

The question is.... how can I tell which button ran the macro, and thus the .Text of that button??

Ive searched for all things to do with controls/buttons/macros in several booka dn online - i guess I don't know what exactly to look for!

any help appreciated.
Andy