For a worksheet: Edit menu/Move or Copy Sheet, Copy it to another workbook and
save that.

For a workbook with many sheets, all to be saved, you would have to go to the
VB Editor and remove all standard modules, forms, and classes, manually remove
all code from ThisWorkbook and Sheet modules.

On Wed, 20 Oct 2004 14:34:57 -0700, "Hugh"
wrote:

Hi there,

How to save a workbook or worksheet without saving the
code? I want to save a single worksheet on a workbook
with columns of data and a chart. However, a form will
pop up if saved file is open since there are code in
workbook. How do I save worksheet (or workbook)without
saving the code? Thanks in advance.

Hugh