Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default Save workbook without code

I have a workbook with a lot of code in modules and userforms. This code is
protected with password but I would like the user can´t save it with the
data. Is there an option to save only the data in the sheet without the
code.
Thanks


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,123
Default Save workbook without code

Hi Juan

In Excel 2007 you can save the file as xlsx but in older versions
You need code to remove it or do it manual

See
http://www.cpearson.com/excel/vbe.aspx



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Juan García" wrote in message ...
I have a workbook with a lot of code in modules and userforms. This code is protected with password but I would like the user can´t
save it with the data. Is there an option to save only the data in the sheet without the code.
Thanks


Reply
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
save workbook without code vqthomf Excel Programming 1 February 7th 08 11:39 AM
code to save the whole folder with a workbook Tim Excel Programming 2 June 30th 05 11:41 PM
Save Workbook without VBA code Ken Loomis Excel Programming 4 March 24th 05 11:38 PM
Error in VBA code to save workbook pikus Excel Programming 1 April 29th 04 03:21 PM


All times are GMT +1. The time now is 08:28 PM.

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

About Us

"It's about Microsoft Excel"