ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   save workbook without code (https://www.excelbanter.com/excel-programming/405725-save-workbook-without-code.html)

vqthomf

save workbook without code
 
Hi I am add some code to help the user to saveas but I want to save the new
workbook without any macro code in it.
Any help will be much appreciated.
Regards
Charles

Gary''s Student

save workbook without code
 
Use a second workbook to remove the modules in the first workbook and then
save the first workbook. See:

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


--
Gary''s Student - gsnu200767


"vqthomf" wrote:

Hi I am add some code to help the user to saveas but I want to save the new
workbook without any macro code in it.
Any help will be much appreciated.
Regards
Charles



All times are GMT +1. The time now is 03:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com