And the question is???
--
HTH...

Jim Thomlinson


"holy41" wrote:

I am using macros to address formulas in certain cells of a workbook. I am
trying to find a way to clear those formulas (tried Workbook_BeforeClose) so
that if my workbook is copied, and then macros are disabled, my work will not
be displayed.
I use a dongle with a code-checking macro for security on the workbook, but
if you copy the book and disable macros, the book still functions and all the
formulas are left in the cells.