Turn off "Ask a Question Box" in VBA

[Hazel O'Sullivan]

Hi

Could someone please tell me how to disable the "Ask a Question Box" in Office XP through VBA code

Thank
Hazel

 

[Mike Labosh]

Could someone please tell me how to disable the "Ask a Question Box" in
Office XP through VBA code.

If I understand the question correctly, you want to get rid of the yellow
balloon that the Office Assistant gives you.

That box is part of the Office Assistant, who lives in the "Microsoft Office
10.0 Object Library"

To use it, put a checkbox on its reference item in the references dialog,
and then you should be able to use this code:

Application.Assistant.On = False

However, most users will be annoyed if your application goes turning off
their paper clip. One thoughtful thing you might do is store the current
state of the "On Property" in a variable before you turn it off, so that you
can reset it to the user's preferred value when your application exits.

 

[Hazel O'Sullivan]

Hi Mike

Thank you so much for your response. Sorry i didn't make myself clear, its not the Office Assistant I'm trying to disable its the help box in office XP located up on the right hand side of the screen with "Type a question for help" in it

Any ideas!

Thank
Hazel

 

[Tushar Mehta]

If you must, though I believe that is one of the few improvements,
albeit marginal, in Office help...

The following might work. Don't know for sure because if it did I
wouldn't know how to restore the Ask a Question box. So, I didn't take
the final step.

To do what you want programmatically, turn on the macro recorder before
carrying out the steps below. Hopefully, you will get the necessary
code.

Select Tools | Customize... With the dialog box open, right click on
the 'ask a question' drop down. You will see an option for 'Show Ask a
Question box' with a checkbox next to it. See if you can uncheck the
box. [I stopped at this point because success might have been hard to
reverse.]

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[Hazel O'Sullivan]

Thanks Tushar for the reply. Using the macro recorder was a great idea but I had managed to sort it before i received your reply.

If anyone is interested here is how i did it

- First I made a reference to 'Microsoft Office 10.0 Object Library' i.e. Tools > Reference
- The Ask a Question Box is part of a command bar called "Menu Bar(custom)" so you just have to disable this command bar as follows
Application.CommandBars("Menu Bar(custom)").Enabled = Fals

That should do it