remove "ask a question box" programatically
 

Hi all,

I would like to remove the "ask a question box" pane. It's a box in Excel
XP-version (a.k.a. Excel 2002). You can find this box on the Worksheet Menu
Bar (bar with File,Edit,Format etc), on the upper right corner.
I have been able to remove it via ViewToolbarsCustomize, and hide it here.
but i want to hide/remove it by using VBA.

Can anybody help?

Thanks in advance

Max Potters

remove "ask a question box" programatically
 

Hi Max

you can disable it by setting:

Application.CommandBars.DisableAskAQuestionDropdow n=False

(xlXP and newer)



keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"Max Potters" wrote:

Hi all,

I would like to remove the "ask a question box" pane. It's a box in
Excel XP-version (a.k.a. Excel 2002). You can find this box on the
Worksheet Menu Bar (bar with File,Edit,Format etc), on the upper right
corner. I have been able to remove it via ViewToolbarsCustomize, and
hide it here. but i want to hide/remove it by using VBA.

Can anybody help?

Thanks in advance

Max Potters