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

Running macro over different sheets for Essbase 11
Macro with Essbase Add-in 5
Hyperion Essbase add-in macro 2
Macro for "Retrieve" in Essbase Menu 1
Diasabling Macro PopUp 5
Macro to insert named range in each sheet 9
Conditional formatting within macro? 3
Hyperion Essbase Excel Add-in - returning text ("0") for null valu 5

Top