OFF97: Cannot Dismiss Office Assistant With Keyboard

Last reviewed: June 4, 1997
Article ID: Q157414
97 WINDOWS kbusage kbprg kbcode kbprb The information in this article applies to:
  • Microsoft Office 97 for Windows
  • Microsoft Excel 97 for Windows
  • Microsoft Word 97 for Windows
  • Microsoft Access 97 for Windows
  • Microsoft PowerPoint 97 for Windows

SYMPTOMS

In the Microsoft Office 97 programs listed at the beginning of this article, there is no key or combination of keys on the keyboard that you can use to dismiss the Office Assistant.

CAUSE

You can only dismiss the Office Assistant by using a mouse or other pointing device.

STATUS

This behavior is by design of the programs included with Microsoft Office 97.

MORE INFORMATION

If you right-click the Office Assistant window in any Microsoft Office 97 program, one of the choices on the shortcut menu that appears is "Hide Assistant". Because the "H" in "Hide" is underlined, if you press "h" while the shortcut menu is visible, the Office Assistant will be dismissed. There is no way to achieve this using only the keyboard.

Microsoft provides examples of Visual Basic for Applications procedures for illustration only, without warranty either expressed or implied, including, but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The Visual Basic procedures in this article are provided 'as is' and Microsoft does not guarantee that they can be used in all situations. While Microsoft support engineers can help explain the functionality of a particular macro, they will not modify these examples to provide added functionality, nor will they help you construct macros to meet your specific needs. If you have limited programming experience, you may want to consult one of the Microsoft Solution Providers. Solution Providers offer a wide range of fee-based services, including creating custom macros. For more information about Microsoft Solution Providers, call Microsoft Customer Information Service at (800) 426-9400.

It is possible, however, to write a Visual Basic for Applications macro to display or hide the Office Assistant. For example:

   Sub ToggleOfficeAssistant()
      Assistant.Visible = Not Assistant.Visible
   End Sub

When you run this macro, if the Office Assistant is visible, it will be dismissed. If the Office Assistant is not visible, it will be displayed. This macro will work in all programs included with Microsoft Office 97.

In Microsoft Excel 97, you can assign a shortcut key to the ToggleOfficeAssistant macro by running the following macro:

   Sub SetShortcutKey()
       Application.MacroOptions Macro:="ToggleOfficeAssistant", _
          HasShortcutKey:=True, ShortcutKey:="o"
   End Sub

Once you have run the SetShortcutKey macro, press CTRL+o (the letter "o") to run the ToggleOfficeAssistant macro and turn your Office Assistant on or off.


KBCategory: kbusage kbprg kbcode kbprb
KBSubcategory: xlui xlhelp xlvbahowto offhelp
Additional reference words: OFF97 XL97 WORD97 ACC97 PPT97
Keywords : offhelp xlhelp xlui xlvbahowto kbcode kbprb kbprg kbusage
Version : 97
Platform : WINDOWS


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: June 4, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.