Where to place Code question
Understood that. Thanks.
Regards.
"zackb" wrote in message
...
Create an additional button called "Export Worksheet" that copies the
worksheet into a new workbook, deletes all the buttons and saves it to
the
name and location of the user's choice. If you have all related code in
modules, none of it will follow the worksheet when it's copied out of the
workbook..
Just to clarify, in case of any confusion (is usually more common with
me),
if there is code in the worksheet module and the entire worksheet (object)
is copied, the code will follow; you must copy the cell *contents*, like a
traditional copy/paste type of effort.
--
Regards,
Zack Barresse, aka firefytr
|