Delete the code in ThisWorkbook
 

Hello Guys,
I'm looking for a bit of code that will let me get rid of the code in
the ThisWorkbook part of a workbook. I have a command button that saves
the workbook and sends it to the specified people. However, when that
workbook is re-opened I don't want the startup code to run again. I'm
thinking of just adding it to the command button. Any ideas?


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Delete the code in ThisWorkbook
 

Hi Darrin

http://www.cpearson.com/excel/vbe.htm
Chip Pearson have a webpage about this subject.


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



"Darrin Henry" wrote in message ...
Hello Guys,
I'm looking for a bit of code that will let me get rid of the code in
the ThisWorkbook part of a workbook. I have a command button that saves
the workbook and sends it to the specified people. However, when that
workbook is re-opened I don't want the startup code to run again. I'm
thinking of just adding it to the command button. Any ideas?


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!