I have this code at the beginning of a macro. I want that macro (if the macro button is pushed) to close the worksheet after 5/31/15. But at this point with the way I have it written, all they have to do is change the system date to 5/30 (or anything before) and the macro will work. I want to know if there is a code that that ensure it closes even if they do backdate the system date. Is this possible? Thank you!
Please Login or Register to view this content.
yes but you didn't know how to do it so I put it back out there to see if anybody else does. It may be impossible, I don't know.
Use the following code - it pulls todays date from an online site, so it won't matter what the system date is.
Set references (in developer environment: tools -> references) to Microsoft XML & Microsoft HTML.
Please click the * below if this helpsPlease Login or Register to view this content.
Please click the * below if this helps
I asked you why you want to do it.
Thank you so much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks