View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Seth[_3_] Seth[_3_] is offline
external usenet poster
 
Posts: 24
Default Disable Excel Prompt

I have a workbook with a DDE formula. If the server is
not open when the Excel workbook is opened, Excel
displays a message asking if the user wants to start the
server application (the dialog reads "Remote data not
accessible. Start application 'appname.exe'?").

Application.DisplayAlerts = False does NOT stop this
message. Even setting the UpdateRemoteReferences to
False for the workbook doesn't stop the message (only
after the workbook is opened does this work).

Is there an effective way to stop this message from
coming up?

Thanks,

Seth