generally you can't, when you save the code is automatically saved. If you simply want to have the contents of the workbook availbel for someone esle without the vba code in its just as easy to write a macro to copy the sheets to a new workbook.
The new workbook would then exist with no code attached.
|