PDA

View Full Version : save workbook without macro's ?



jonp
08-17-2007, 03:24 AM
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
08-17-2007, 04:40 AM
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
08-18-2007, 02:39 AM
thankyou very much
i will give it a try