Macro with an end date

I am currently using the following at the beginning of a macro to give it an end date. However, this can be easily manipulated by changing the computer's system date. Is there a way to make it where the system date will not matter? Thank you!

Please Login or Register  to view this content.

Please Login or Register  to view this content.

But won't that just close the workbook no matter what the date is? I want to be able to specify a date or a number of days remaining if possible. Thank you!

Date is the system date. You can add plus and minus to date,like
Date-1 is yesterday.

Then the exdate will always be equal to the system date and will never shutdown with the way I have it written. Would I have to add another line or 2? Please help. Thanks.

I am not sure I understood your request, but you can add else statement or do elseif

Please Login or Register  to view this content.

I will try and explain it better then. I have that 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. Does that make more sense? Thank you!

The simple answer is: I do not know.

Thanks and I love your honesty!! I appreciate the attempt!