generating sheet with command button & code
 

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)

generating sheet with command button & code
 

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

generating sheet with command button & code
 

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
.

generating sheet with command button & code
 

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
.

generating sheet with command button & code
 

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


"Tom Ogilvy" wrote in message
...
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
.