Autosave:: off
easy with your code add the lines application.displayalerts=false (T turn that message off) and then the same but with true (to turn tha message back on) *N.B REMEMBER TO TURN THEM BACK ON ELSE YOU WILL NOT RECEIVE MESSAGE FROM EXCEL AGAIN UNTIL YOU TURN IT BACK ON!* Hope this help -- funkymonkU ----------------------------------------------------------------------- funkymonkUK's Profile: http://www.excelforum.com/member.php...fo&userid=1813 View this thread: http://www.excelforum.com/showthread.php?threadid=39014 |
All times are GMT +1. The time now is 05:25 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com