Macro for "Retrieve" in Essbase Menu

R

raizwai

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!
 
T

Thyagaraj

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!
Click to expand...

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro for "Retrieve" in Essbase Menu 1
Running macro over different sheets for Essbase 11
Diasabling Macro PopUp 5
Macro Pop Up 9
Stopping a macro to edit the template then re-saving the macro for use 4
How to create pop menu in macro ? 1
Macros Menu in Excel 2007 2
Macro for Retrieving data from closed workbook with date in title 2

Top