This file might be a help:
http://www.bygsoftware.com/examples/...s/apcaller.zip
It's in the "Worksheet with VBA" section on page:
http://www.bygsoftware.com/examples/examples.htm
A short demo that reports which of three buttons was pressed
--
Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"
"Dr. Schwartz" wrote in message
...
I have 16 contol buttons that all launch the same sub. How can I make the
code recognise which button was pressed?
Is there a way to rename (not the text) a button differently from what
Excel assigns?
Any help is appriciated
Schwartz