ExcelBanter - save excel as data only to a new workbook using VB

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - save excel as data only to a new workbook using VB (https://www.excelbanter.com/excel-discussion-misc-queries/116649-save-excel-data-only-new-workbook-using-vbulletin.html)

Haldane

save excel as data only to a new workbook using VB

I wonder if anyone can help.

I have a workbook with VB proect, date picker objects etc. I need to be able
to create a copy of the work book when it is finally closed as complete. The
copy that it creates needs to be protected and only contain the data ie no
formulas VB etc.

Be grateful if anyone can help

Thanks

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