View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
davesexcel[_107_] davesexcel[_107_] is offline
external usenet poster
 
Posts: 1
Default Avoiding the 'Update Values' dialogue


Application.DisplayAlerts = False

'your macro

at the end of the macro

Application.DisplayAlerts = True


--
davesexcel


------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=539622