Hi,


I am trying to automate an essbase retrieval process/essbase prompt box. Below is the code.When the marco is running there is a essbae message box that pops up (which states that the sheet contains unknown members). I would need to click no ever time the marco is running for the specified sheet. I tried the application.display alert code bu tno luck. I just need the prompt box either to not show up or automate the process by saying "no" to the message.Any help is much appreciated!!

Sub RetrieveAll()
Application.DisplayAlerts = False
Sheets("US MedDevices").Select
Range("A1:AA200").Select
Application.Run ("EssMenuRetrieve")
Application.DisplayAlerts = True

End Sub