Why not just create a new workbook and copy all of the relevant data to
that, sans macros?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"ChadF" wrote in message
...
I've got an application that uses a bunch of behind-the-scenes macros.

The product that I'm building needs to be a copy of the original worksheet
that
contains the set of macros used to build it.

However, I dont want my end-users messing with the output product per se.
(They just want to see the numbers that built the document, namely
itself. )

Most painless way I found was simply putting all my values together to an
output set of worksheets (which was really just a set of hidden sheets on
the
workbook) and then doing a SaveAs to something else.

Question I have is - how do I programmatically disable all the macros on a
given worksheet ?? It's not the statement Application.Enableevents =
false
(although that does help neuter the Worksheet_Change event)

Appreciate any advice.

Thanks,
Chad