Thanks for the code and guidance.
Regards.
"Tom Ogilvy" wrote in message
...
Easier to have the generalized code in a general module and use a button
from the forms toolbar. then you just add it (macro recorder) and assign
it to the macro. (OnAction property).
In the generalized code
Sub General_Button_Click()
sName = Application.Caller
btn = Activesheet.Buttons(sName)
msgbox btn.Caption
End Sub
Or
http://www.cpearson.com/excel/vbe.htm
and the macro recorder shows how to copy or add a commandbutton. (why
copy - just add it and format it as you wish with code).
--
Regards,
Tom Ogilvy
"Stuart" wrote in message
...
I have a workbook with a Master and Summary sheet.
It will become a Template, (or perhaps read only xls).
Buttons on the Master allow the user to do simple things like add a
sheet,
reorder sheets, etc.
When they add a sheet via the button on the Master, I'd like to copy a
hidden button from the Master, and place it on the new sheet (including
the
code).
Can I do this, and if so, how, please?
Regards.