LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,123
Default 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?











 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
can not save if this code is in the workbook jlclyde Excel Discussion (Misc queries) 0 December 17th 08 10:21 PM
Locking VBA code via Project properties but cannot save the workbook over itself Shane Excel Programming 4 July 27th 04 01:00 AM
Error in VBA code to save workbook djchristie Excel Programming 0 April 29th 04 03:26 PM
Error in VBA code to save workbook pikus Excel Programming 1 April 29th 04 03:21 PM
Automatically run VB code on workbook save event Tim[_32_] Excel Programming 2 December 10th 03 08:06 PM


All times are GMT +1. The time now is 09:06 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"