generating sheet with command button & code

  • Thread starter Thread starter Bob
  • Start date Start date
B

Bob

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)
 
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)
Click to expand...

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
 
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?
 
Bob,

Why not create a template file (or sheet) with the controls alread embedded
and add the data to that, then save as a new file?

Alex@JPCS
 
Back
Top