I have a spreadsheet and a macro that creates a new sheet and enters some data into the sheet. The user gets to make some changes to the created sheet and then prints it out. I was wandering if there was any way to have a message coming up every 10 minutes remindnig the user about the new sheet untill it was printed out and then the warnings would stop. Could anyone sugest a good way to do that?
Thank you in advance!
Last edited by SER01; 06-14-2009 at 07:37 PM.
See Help in the VBE for the OnTime method.
Entia non sunt multiplicanda sine necessitate
Thank you, your sugestion did get me in the right direction. This is the code that i have that displays the warning 4 times at 5 sec intervals. My question is how would i cancel the event before the end of the loop at the execution of a different macro
Please Login or Register to view this content.
Any sugestions, anyone?
Don't schedule it multiple times; schedule it once, and put the schedule time in a public variable.
When the MsgBox routine pops up, have it reschedule itself for 5 minutes hence (and, again put the schedule time in the public variable).
In the Workbook_BeforePrint event, unschedule the macro using the public variable as shown in the example in Help.
I'm sorry but i am very green when it comes to vba.Originally Posted by shg
How would i declare a public variable? Should the event be scheduled in a macro or somwhere else?
Thank you!
In a code module:
In ThisWorkbook modulePlease Login or Register to view this content.
Please Login or Register to view this content.
Thank you very much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks