Look at Chip Pearson's site for programming the VBE
http://www.cpearson.com/excel/vbe.htm
You can turn on the macro recorder and get the code for adding a button.
John Walkenbach also has sample code for creating controls on a userform
dynamically. It should still be useful for creating controls on a sheet
http://www.j-walk.com/ss/excel go to developer tips and then tips on
userforms.
Regards,
Tom Ogilvy
"Bob" wrote in message
...
Thanks for the reply but I'm looking for something a bit
different. I'm sorry I didn't make myself clear. I need
to place a command button with corresponding code in the
GENERATED workbook (say, on Sheet2). I need to do this
from the code of the master workbook. Any ideas of how to
accomplish this?
-----Original Message-----
On Mon, 4 Aug 2003 01:44:26 -0700, Bob wrote:
Hey everybody,
I'm a little new to Excel soln dev so bear with me...
I have a master workbook with a button that generates
other workbooks. That works fine but now I have to
include
a button (cmdGo) with corresponding code (cmdGo_Click
()).
How do I do this in the code of the master workbook?
Any
help, direction or example would be greatly
appreciated.
Thanks a lot in advance!
Bob (please reply to group)
Did you define a procedure name? If so, try this:
**********
Private Sub cmdGo_Click()
Call MyProcedure
End Sub
**********
This will start the procedure 'MyProcedure', which should
be included in
the workbook.
Good luck...
SL
.