Save Workbook without VBA code
 

Is there a way to save a copy of a workbook that will not include the VBA
project?

Save Workbook without VBA code
 

yes but you would have to code it into the before save event
and access to visual basic project would need to be trusted, so that you
could delete the entire project through code, though, trying to remove the
module that is running might create unpredictable behavoiur......

"Ken Loomis" wrote:


Is there a way to save a copy of a workbook that will not include the VBA
project?

Save Workbook without VBA code
 

http://www.cpearson.com/excel/vbe.htm
Chip Pearson's page on coding the VBE

might be of use.

--
Regards,
Tom Ogilvy


"Ken Loomis" wrote in message
...

Is there a way to save a copy of a workbook that will not include the VBA
project?

Save Workbook without VBA code
 

Thanks, that gave me all I needed. I just need to be sure the distibution
copy doesn't contain my coding, so I use the " Deleting All Code From A
Module " example and thAT DID THE TRICK.

Ken

"Tom Ogilvy" wrote in message
...
http://www.cpearson.com/excel/vbe.htm
Chip Pearson's page on coding the VBE

might be of use.

--
Regards,
Tom Ogilvy


"Ken Loomis" wrote in message
...

Is there a way to save a copy of a workbook that will not include the VBA
project?

Save Workbook without VBA code
 

Hi Ken

If you want to mail the workbook then you can do it all in one step with this Add-in.
there is a option to delte the VBA in this Add-in
http://www.rondebruin.nl/mail/add-in.htm

I always send the workbook to myself if I want a clean copy



--
Regards Ron de Bruin
http://www.rondebruin.nl



"Ken Loomis" wrote in message ...
Thanks, that gave me all I needed. I just need to be sure the distibution copy doesn't contain my coding, so I use the " Deleting
All Code From A Module " example and thAT DID THE TRICK.

Ken

"Tom Ogilvy" wrote in message ...
http://www.cpearson.com/excel/vbe.htm
Chip Pearson's page on coding the VBE

might be of use.

--
Regards,
Tom Ogilvy


"Ken Loomis" wrote in message
...

Is there a way to save a copy of a workbook that will not include the VBA
project?