Thread: Excecl VBA: When a Dialog Appears that requires you to press "OK"
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
RB Smissaert RB Smissaert is offline
external usenet poster
  
Posts: 2,452
Default Excecl VBA: When a Dialog Appears that requires you to press "OK"
Try:

Application.DisplayAlerts = False

'run all your code here

Application.DisplayAlerts = True


RBS

"Bruce" wrote in message
...
In VBA code, how can I handel a Microsoft Office Excel Dialog that pops
up?
All I need to do is recogise that the dialog has appeard and press "OK".
--
Thanks
Bruce

Reply With QuoteReply With Quote