MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Dave..plz help me with this macros..

Posted by Joe on April 03, 2001 8:05 AM

Hello 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
whatnot. :)
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

Posted by Dave Hawley on April 03, 2001 8:33 AM

Hi Joe

The first time I read your question I didn't really read the detail. Since then I have and I must say that I am not willing to supply code for this, as I have a business to look after and supplying code for this purpose would be morally

I do however sympathise with you, as it was a similar circumstance that pushed me into starting my own business. I too could have taken your path but chose not too, as the long term ramifications
would far out-weigh the short term satisfaction.

All I can suggest is be straight with your boss and tell him/her you feel you are being used and are concerened you will be out of work. You never know, it may work in your favour.

OzGrid Business Applications

Posted by Rick M. on April 03, 2001 2:30 PM

Bravo Dave Hawley!