save workbook without macro's ?

[jonp]

I have written a workbook to automate the prosses of creating a work sheet for billing engineers time and costs. once the macros have done their job i am left with a pdf of the work sheet and a archive saveas xls the xls save name is the windows user name + report number. is it possable to strip the macros from the resultant report when i save via a macro?

[anandbohra]

Try this. (Not my project just found it in Excel forums where i am registered)

This file delete its own VBA codes, References, Programming objects etc.

this file is in read only mode before running macro do this.
Tools - Macro - Security
under Trusted Publishers tick Trust Access to Visual Basic Project check box.

[jonp]

thankyou very much
i will give it a try