I am using the following code to put an expiration date on a macro but I want it to automatically close the file without saving it when they hit the OK button for the message box. With this, you can "cancel" the save and it will bypass it. What changes do I need to make? Thanks.
Please Login or Register to view this content.
Hi, backyardfun,
you should not consider that change to make the application failsafe.
Ciao,Please Login or Register to view this content.
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
have you tried something likePlease Login or Register to view this content.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
I am not putting it in an auto-open macro, so that will be ok right?
The False addition worked, thank you. This is the code with the rest of it. Is there a way to make the "days left" part show only when it gets within 7 days of the expiration date?
Please Login or Register to view this content.
Hi, backyardfun,
Stop should not be the name of a procedure as it is a VBA command.
And how will you start the procedure if not via Auto_Open/Workbook_Open?
Ciao,Please Login or Register to view this content.
Holger
My bad, I just used the name stop as a dummy name. It is not a macro by itself, so I should not have even used the sub, end sub lines. This code is placed (without the sub, end sub) in the beginning of the most important macro in the worksheet. The file will be able to be opened and navigated around until this macro is ran. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks