Can I create a worksheet with command buttons, hyperlinks, and code in the
worksheet module, and then copy this entire sheet with everything intact
into a new workbook?

Ed

Yes you can Ed

Sheets("Sheet1").Copy will create a new workbook with that sheet.

Only you must use buttons from the Control toolbox and place your code in the click event.
The button will always follow the click event and this is in the sheet module.

If you use a Forms button and assign a macro to it
The macro is in a normal module and not
in the sheet module so this will not work





--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Ed" wrote in message ...
Can I create a worksheet with command buttons, hyperlinks, and code in the
worksheet module, and then copy this entire sheet with everything intact
into a new workbook?

Ed

Thank you, Ron. I'll work with this. If things start smoking, I'll yell
for help! 8)

Ed

"Ron de Bruin" wrote in message
...
Yes you can Ed

Sheets("Sheet1").Copy will create a new workbook with that sheet.

Only you must use buttons from the Control toolbox and place your code in
the click event.
The button will always follow the click event and this is in the sheet
module.

If you use a Forms button and assign a macro to it
The macro is in a normal module and not
in the sheet module so this will not work





--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Ed" wrote in message
...
Can I create a worksheet with command buttons, hyperlinks, and code in
the
worksheet module, and then copy this entire sheet with everything intact
into a new workbook?

Ed