Hi!
In one of the workbook, i use a code like this...when it reaches expiry date it gvies pop up...& then closes it...so there is no way (as for me I dont know a way) to stop it from closing as u all know how fast the macro is....I was trying to re-open and change the setting but it does not...