View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
keepITcool keepITcool is offline
external usenet poster
 
Posts: 2,253
Default 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