Dave..plz help me with this macros..
Posted by Joe on April 03, 2001 8:05 AM
Hello Dave..how about clear all vb macros too..i mean delete vb macro on certain dates..any
those that read my previous messages may recall that i'm a temp in a fairly large company. i'm
trying to get a full time job here (anywhere) - i've dropped many hints, gone over and beyond my call
of duty, etc. (the spreadsheet that you guys helped me on (which works fabulously btw) being one
example.) .. anyway, i was wondering if there is a way to program a "self destruct" on a certain date.
i don't want to erase all of the data, just the formulas which calculate everything that they had been
doing manually for years before i was asked to automate it. .. just for the sake of job security and
select "View Code"). Set AllFormulas = Nothing Next Sht Application.CutCopyMode = False End If End Sub
Change the date to suit. This will convert all formulas to Values after the date you specify. You should be aware that you will need to Lock the VBE for viewing if you do not want users
venturing in and removing your code. You should also know that if the Workbook is opened from within Excel and the user holds down
the Shift key, the Workbook_Open will not fire. Dave