Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 43
Default 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


  #2   Report Post  
Posted to microsoft.public.excel.programming
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




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
=SUBSTITUTE(C4,"~?#","") will this work to remove multiple string Raja Mahendiran S Excel Worksheet Functions 6 May 12th 10 09:10 PM
Programatically adding macro to Excel - "ThisWorkbook" Aerojade Excel Discussion (Misc queries) 3 October 1st 08 12:53 PM
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell Steve Kay Excel Discussion (Misc queries) 2 August 8th 08 01:54 AM
"Disk is Full" add-on question to "Can't reset last cell" post tod [email protected] Excel Discussion (Misc queries) 0 January 22nd 07 02:32 AM
How to do the "REDO" action in Excel programatically. Daffo Excel Discussion (Misc queries) 2 December 4th 06 11:41 AM


All times are GMT +1. The time now is 01:06 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"