ExcelBanter - Save workbook not macro

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Save workbook not macro (https://www.excelbanter.com/excel-programming/394730-save-workbook-not-macro.html)

[email protected]

Save workbook not macro

Is there a way to save a workbook to a new name but not save the macro

Jim Cone

Save workbook not macro

Sheets.Copy
ActiveWorkbook.SaveAs "NewName"
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)

wrote in message
Is there a way to save a workbook to a new name but not save the macro

All times are GMT +1. The time now is 04:54 PM.