Create Excel Add in for Essbase

[Nigel]

I am trying to create an excel add in that will allow the suer to select the
next zoom level without having to go to the essbase options

Ideally I would like to have 1 button that would allow the user to select
one of three options Next, All Levels and Bottom Level

Obviously this would require a form to pop up and the form is no problem

its the code to switch between the 3 levels of drill down I am needing
assistance with and to change its caption to the level being zoomed to



thanks in advance

 

[Nigel]

I have achieved this goal but having trouble setting the retain on retrieval
mode,

I need to check and see if retain on retrieval is true or false and if false
set it to true and vise versa, any suggestions anyone