View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
holy41 holy41 is offline
external usenet poster
 
Posts: 11
Default using macros to insert and remove calculations a the workbook

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.