Cannot Disable ToolTips Directly from Microsoft Query (107254)


The information in this article applies to:

  • Microsoft Excel for Windows 95
  • Microsoft Excel for Windows 5.0
  • Microsoft Query
This article was previously published under Q107254
IMPORTANT: This article contains information about editing the registry. Before you edit the registry, you should first make a backup copy of the registry files (System.dat and User.dat). Both are hidden files in the Windows folder.

SUMMARY

You cannot disable ToolTips from within Microsoft Query. If you do not want ToolTips to be displayed, do the following according to the version of Microsoft Query you are using:

Microsoft Query for Windows 95, version 2.0

WARNING: Using Registry Editor incorrectly can cause serious problems that may require you to reinstall Windows 95. Microsoft cannot guarantee that problems resulting from the incorrect use of Registry Editor can be solved. Use Registry Editor at your own risk.
For information about how to edit the registry, view the Changing Keys And Values online Help topic in Registry Editor (Regedit.exe). Note that you should make a backup copy of the registry files (System.dat and User.dat) before you edit the registry.

  1. Click the Start button, and then click Run.
  2. In the Open box, type "regedit", without quotes.
  3. Locate the HKEY_CURRENT_USER registry folder.
  4. Expand the HKEY_CURRENT_USER folder until you locate the "SOFTWARE\Microsoft\Query\2.0\Microsoft Query" folder.
  5. Click the Microsoft Query folder.
  6. On the Edit Menu in the Registry Editor, click New, and then click Dword Value.
  7. Type "Tooltips" (without the quotation marks), and then press ENTER.
  8. Click Exit on the Registry menu to exit the Registry Editor.
Using the steps above, the new Tooltips key will be set to 0. When this key is 0, the tooltips will not display in Microsoft Query 2.0. To display the tooltips in Microsoft Query again, either set the Tooltips key to 1 or delete the Tooltips key.

Microsoft Query, version 1.0

Change the MSQUERY.INI file:

  1. If you are in Microsoft Query, quit the application.
  2. Use a text editor, such as Windows Notepad, to open the MSQUERY.INI file (this file should be located in the WINDOWS directory).
  3. In the [Microsoft Query] section of MSQUERY.INI, add the following line:

    ToolTips=0
  4. Save the MSQUERY.INI file and quit the text editor.
When you restart Microsoft Query, ToolTips will no longer appear.

To re-enable ToolTips, remove the "ToolTips=0" line from the MSQUERY.INI file.



For more information about the entries in the MSQUERY.INI file, please see the following article(s) in the Microsoft Knowledge Base:

112448 : MSQuery: Valid Settings for the .INI File for Microsoft Query
Modification Type:MinorLast Reviewed:8/15/2005
Keywords:KB107254
©2004 Microsoft Corporation. All rights reserved.