remove "ask a question box" programatically

[Max Potters]

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 View>Toolbars>Customize, and hide it here.
but i want to hide/remove it by using VBA.

Can anybody help?

Thanks in advance

Max Potters

 

[keepITcool]

Hi Max

you can disable it by setting:

Application.CommandBars.DisableAskAQuestionDropdown=False

(xlXP and newer)



keepITcool

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