Thread: Macro for "Retrieve" in Essbase Menu
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Thyagaraj Thyagaraj is offline
external usenet poster
  
Posts: 51
Default Macro for "Retrieve" in Essbase Menu

wrote:
When retriving Essbase using macro, if there are other text in the
sheet(other than the essbase's own formatting), warning msg will pop-up
everytime. Is there any ways to disable these pop-ups which will
disturb the retrieving? Tks!

Dear raizwai,

Use the following code at the beginning of your macro code
Application.DisplayAlerts = False

Use the Following code at the end of your macro code
Application.DisplayAlerts = True

Regards
Thyagaraj

Reply With QuoteReply With Quote