Hello Dave..how about clear all vb macros too..i mean delete vb macro on certain dates..any ideas..t


Posted by ed on April 01, 2001 4:37 AM


Hello Dave..how about clear all vb macros
too..i mean delete vb macro on certain
dates..any ideas..thanks


[ Follow Ups ] [ Post Followup ] [ Mr Excel's Message Board for Excel Help ] [ FAQ ]


Posted by ed on March 29, 2001 at 19:57:49:

In Reply to: Re: self destruct? posted by Dave Hawley on March 29, 2001 at 17:27:05:
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. :)
right?
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 Lawyer on April 01, 2001 5:34 AM

Hello Dave..how about clear all vb macros too..i mean delete vb macro on certain dates..any ideas..thanks [ Follow Ups ] [ Post Followup ] [ Mr Excel's Message Board for Excel Help ] [ FAQ ] Posted by ed on March 29, 2001 at 19:57:49: In Reply to: Re: self destruct? posted by Dave Hawley on March 29, 2001 at 17:27:05

Posted by Lawyer on April 01, 2001 5:34 AM

Grow up.

Hello Dave..how about clear all vb macros too..i mean delete vb macro on certain dates..any ideas..thanks [ Follow Ups ] [ Post Followup ] [ Mr Excel's Message Board for Excel Help ] [ FAQ ] Posted by ed on March 29, 2001 at 19:57:49: In Reply to: Re: self destruct? posted by Dave Hawley on March 29, 2001 at 17:27:05


What you are trying to do is the willful destruction of someone else's property - in law this is known as malicious damage and is a criminal act. Anyone who helps you to do what you want would be guilty of aiding and abetting a criminal act.

Posted by Watcher on April 01, 2001 7:17 AM

Re: Grow up. WHAT IS YOUR PROBLEM DUDE>MIND YOUR OWN BUSINESS..THIS IS AN INTERACTIVE BOARD..BUZZ OFF.GET A LIFE

Posted by Lawyer on April 01, 2001 1:16 PM

Thank you

Thank you for your contribution.
Was merely putting in my two cents worth, just like you.
Just trying to provide some information that some people might find useful. Of course, no-one is obligated to follow any such advice - either mine or yours.



Posted by Andrew Leeson on April 26, 2001 5:28 AM

Backups

If you're working for an organization that has any
sense at all your data will be backed up each night.
You can delete all you want but they can go back to
yesterdays (or last weeks) copy of the file and
remove all your time based stuff.

Incidentally they could catch you this way too.

Just thought I'd mention it!