Microsoft KB Archive/162040

XL97: Excel Articles Available by E-Mail: User Interface

---

The information in this article applies to:

• Microsoft Excel 97 for Windows

---

SUMMARY

This article shows you how to obtain support information from the Microsoft Knowledge Base by e-mail. If you are currently viewing this article on the World Wide Web, this information may not pertain to you.

MORE INFORMATION

The "Article Listing" section of this article includes a subset of Knowledge Base articles about the user interface in Microsoft Excel 97. Use the instructions in the "Ordering Articles by E-Mail" section of this article to order items from this list.

Note that because Microsoft Technical Support is constantly adding new information to the Knowledge Base, not all articles are listed here. For this reason, you may want to look on the Web to find the information you are looking for. Microsoft Technical Support on the Web is located at the following address on the World Wide Web:

http://support.microsoft.com/support/default.asp

Ordering an Article by E-Mail

To have an article from the list sent to you in e-mail, send a message to mshelp@microsoft.com, and use the Article ID in the subject line of the message, as in the following example:

TO: mshelp@microsoft.com
SUBJECT: Q119591

For more information about how to order an article by e-mail, send an e- mail message to the following e-mail address:

mshelp@microsoft.com

ARTICLE LISTING

ARTICLE ID ARTICLE TITLE

Q63807 XL: Finding/Replacing Tildes and Wildcard Characters

Q108033 XL: Can't Hide/Unhide Sheets if Workbook Contents Protected
Q108474 XL: Window Options Are Not Saved in Workspace File
Q109064 XL: Visual Basic Macro to Hide and Restore All Toolbars
Q115775 XL: Visual Basic Activate Method Unhides Hidden Windows


Q117855 XL: Removing the Control Menu and Application Window Controls
Q119718 XL: Can't Synchronize Windows By Choosing Arrange All
Q125847 XL: Unexpected Behavior with Attached Toolbars
Q130045 XL: Can't Use Scroll Bar on Number Tab in Format Cells Dialog
Q134334 XL: Text on Worksheet Tab Is Compressed or Clipped


Q135637 XL: Disables Energy Saving Features of Monitors
Q141574 XL: How to Create Macro That Opens Multiple Selected Files
Q141576 How to Save Personal Macro Workbook When MS Excel Is Open
Q142119 XL: How to use a Macro to Enter Cell Note Text in a Text Box
Q142135 How to Use the Forms Controls on a Worksheet


Q143458 XL97: Cannot Move or Copy Sheet After Last Sheet
Q146197 XL: How to Find Technical Information About Microsoft Excel
Q150360 XL: How To Share Custom AutoFill List
Q156000 XL97: Additional Controls Dialog may not use Long Filenames
Q156008 XL97: "Reference Is not Valid" Error Clicking Hyperlink


Q156044 XL97: Pick From List Limited to 255 Characters
Q156164 XL97: CTRL+ALT+TAB Does Not Insert Tab into Active Cell
Q156314 XL97: How to Use the PivotTable AutoSort Feature
Q156419 XL97: No WorkGroup Toolbar in Microsoft Excel 97
Q156442 XL97: No "Center Across Columns" Toolbar Button


Q156446 XL97: "That Command Cannot Be Used" Inserting Columns or Rows
Q156450 XL97: No Info Window in Microsoft Excel 97
Q156603 XL97: Microsoft Excel Inserts a Defined Name in Formula
Q156646 OFF97: Error Modifying File Properties with Long Date Format


Q156650 XL97: Cannot Drag Drawing Objects Between Worksheets
Q156836 XL97: CTRL+SHIFT+" Keyboard Shortcut Limited to 1,024 Characters
Q156869 XL97: Pasting Entire Column Is Slower than in Earlier Versions
Q156879 XL97: Visual Basic Modules Cannot Be Hidden or Protected
Q156881 XL97: Only 1024 Characters Are Displayed in a Cell


Q156882 XL97 Err Msg: "Name Conflicts with Existing Module"
Q156883 XL97: "Create Hyperlink Here" Does Not Work in Unsaved File
Q156891 XL97: Undo Does Not Always Restore Previous Value
Q156892 XL97: MS Excel Stops After Specifying Conditional Format
Q156941 XL97: Forward Button on Web Toolbar May Not Be Available


Q156942 XL97: How to Create an Add-in File in Microsoft Excel 97
Q156943 XL97: How to Convert an Add-in File into a Workbook
Q156983 XL97: Print Titles with Merged Cells Add Columns or Rows
Q156984 XL97: Cannot Drag Drawing Objects onto Windows Desktop
Q156987 XL: Sheet Protection Does Not Disable Options Settings


Q157027 XL97: Attached Toolbar Is Not Saved in 5.0/95 File Format
Q157034 XL97: Cannot Use External References with Data Validation
Q157087 XL97: Cannot Modify or Delete Custom Menus
Q157095 XL97: Natural Language Formulas Return Error
Q157104 XL97: Errors When Trying to Make Office Assistant Visible


Q157108 XL97: Options not Available in Macro Options Dialog Box
Q157111 XL97: Error When Sorting a Range Containing Merged Cells
Q157112 XL97: Cell References in Copied Formula Incorrect
Q157165 XL97: Add to List Button Is Dimmed in Advanced Find Dialog Box
Q157202 XL97: Color Palette Looks Different in Microsoft Excel 97


Q157203 XL97: Cannot Add Macros to the Tools Menu
Q157204 XL97: Odd Behavior Using Format Painter and Merged Cells
Q157303 XL97: Extended Characters in Text or Property Inaccurate
Q157304 XL97: Cannot Drag UserForm Control Onto a Worksheet
Q157346 XL97: Code "Behind" Worksheet or Workbook may not Work


Q157348 XL97: All Views Listed in Custom Views and Report Manager
Q157412 XL97: Select Method May Select More Cells Than Expected
Q157415 XL97: TabStrip Information Missing from Value Property Help
Q157553 XL97: Dialog Boxes and UserForms Use Tahoma Font


Q157554 XL97: RefEdit Control in Binder Does Not Collapse
Q157610 XL97: Problems When AutoFilling Very Large Time Frames
Q157611 XL97: Menubars and Toolbars Flash When You Close a Workbook
Q157750 XL97: IntelliMouse Cannot Zoom Beyond 100%
Q157754 XL97: Problems When Disabling/Enabling Menus in MS Excel 97


Q157758 XL97: Clicking Cancel Button May Not Dismiss UserForm
Q157768 XL97: Not all Menu Items Appear for Other Users
Q157769 XL97: How to Delete, Restore, and Edit Menu Items Manually
Q157952 XL97: Customize Dialog Stays Behind Toolbars When Clicked
Q157957 Query97: Redraw Problems in Choose Columns Dialog Box


Q157958 XL97: No "Record at Mark" Feature in Microsoft Excel
Q157986 XL97: Unexpected Behavior for RefEdit Control in Binder
Q158079 XL97: How to Use the Internet Assistant Wizard
Q158434 XL97: Cannot Make Changes to Some Shortcut Menus
Q158540 XL97: Results Do Not Change After Toggling Transition Formula Evaluation


Q158550 XL97: Problems Disabling and Enabling Shortcut Menus
Q158632 XL97: Limitations for Naming Visual Basic Modules
Q158639 XL97: Edit Box Does Not Appear in ToolBox
Q158711 XL97: Cannot Edit Text Box with Unlocked Text
Q158749 XL97: No Data Validation Property for UserForm TextBoxes


Q159230XL97: Clicking Microsoft Excel on Taskbar Does not Work
Q159338 XL97: Imported Toolbox Page Loses Caption and Tip Text
Q159403 XL97: Data Validation Is Only Accurate with Manual Entry
Q159465 XL97: "Module Not Found" Error Opening Workbook
Q159474 XL97: Startup Switches for Microsoft Excel 97


Q159489 XL97: Grouping ActiveX Option Buttons on a Worksheet
Q159491 XL: Text or Number Converted to Unintended Number Format
Q159537 XL97: Cannot Import/Export UserForms Between VBE and VB4.0
Q159619 XL97: Sample Macros for Customizing Menus and Submenus
Q159669 XL97: Illegal Operation Saving Workbook


Q159715 XL97: Resetting Toolbox to Default Controls and Layout
Q159725 XL97: Map Object Different Depending on Insertion Method
Q159729 XL97: "255 Characters in Cell" Error when Copying Worksheet
Q159756 XL97: Cannot Rename Worksheet to History
Q159858 XL97: Macro Error Accessing OLEObject on Worksheet


Q159914 XL97: Bitmap Image Shrinks When Pasted on a Toolbar Button
Q159997 XL97: Illegal Operation Closing File When VBE Is Visible
Q160058 XL97: Error Changing Order of Option Buttons on a Dialog Sheet
Q160264 XL: Workspace Doesn't Retain Window Size
Q160333 XL97: Warning Saving Workbook if It Contains a Sound Note


Q160457 XL97: "Exit Design Mode" Deactivates Visual Basic Editor
Q160473 XL97: How to Create a Template for a Toolbox Control
Q160489 XL97: Menu Editor and Make Add-In Dialog Boxes Cause Error
Q160520 XL97: Error Adding or Deleting a Menu Command in a Macro
Q160600 XL97: ScreenUpdating Causes Problems in MS Internet Explorer


Q160767 XL97: Cursor and Cell Disappear Editing Text in Cell
Q160903 You Cannot Enable or Disable Built-in Commands with a Macro
Q160956 XL97: Sample Macro to Remove User Name from Comment
Q161072 XL97: Cannot Use Mouse to Populate RowSource or ListFillRange
Q161241 XL97: Data Overwritten Copying More Than 31,737 Characters


Q161322 XL97: How to Use Custom Toolbars in Excel5.xlb
Q161440 XL97: How to Disable Shortcut Menus
Q161486 XL97: Macro to Change File Type to "All Files (*.*)" in Open Dialog Box
Q161496 XL97: How to Customize a Custom Toolbar Button
Q161509 XL97: Status Bar Text Not Displayed When You Point to Toolbar or Menu Item


Q161514 XL97: How to Use a UserForm for Entering Data
Q161535 XL97: How to Simulate a Paused Visual Basic Procedure
Q161546 XL97: How the Current Mode of Calculation Is Determined
Q161609 XL97: Changes to Microsoft Visual Basic for Applications
Q161677 XL97: How to Record a Macro Using Relative Cell References


Q161694 XL97: Control Toolbox Toolbar Disappears
Q161746 XL97: Pointer Does Not Change into Hand with ActiveX Controls
Q161789 XL97: Background Color Is Not Updated in ActiveX Control
Q161816 XL97: Min Can Exceed Max on ScrollBar or SpinButton Control
Q161836 XL97: Deactivate Event Doesn't Occur After Moving Sheet


Q161903 XL97: How to Determine the Key Pressed Along with Mouse Button
Q161926 XL97: How to Place a Checkmark Next to a Menu Item
Q163269 Off97: Menu Disappears with Kensington TrackBall
Q164164 XL97: Setting Zoom to 39% or Less Changes Worksheet Appearance
Q164919 XL97: Scrolling Through Worksheet Causes MS Excel to Pause


Q165240 XL97: Redo Toolbar Button Does Not Repeat Formatting
Q165258 XL97: Pressing ALT+F11 May Not Start the Visual Basic Editor
Q165450 XL97: Error Inserting ActiveX Object in a Worksheet
Q165493 XL97: Conditional Formats May Not Work on Rich Text Cells
Q165501 XL97: Returning Values from ListBox Displaying Multiple Columns


Q165570 XL97: How to Use the TextColumn Property
Q165632 XL97: How to Remove All Items from a ListBox or ComboBox
Q165979 XL97: Borders Appear in Printed Workbook Using Track Changes
Q166093 XL97: Invalid Page Fault Using DropDown Method with ComboBox
Q166341 XL97: Preventing UserForm from Being Dismissed with Close Button


Q166347 XL97: Using the SheetChange Event in Microsoft Excel 97
Q166450 XL97: Macro to Tile Windows Does Not Work with Minimized Window
Q166880 XL97: Most Recently Used List Is Not Updated
Q166932 XL97: List Box Doesn't Work Correctly When Workbook Is Hidden
Q167076 XL97: Text Problems in Controls When Worksheet is Zoomed

Q170449 XL97: Cannot Paste Picture into UserForm

Additional query words: 8.00 XL97 Fast tips msears excel8 excel97

Keywords : kbualink97 xlui
Version : WINDOWS:97
Platform : WINDOWS
Issue type : kbinfo
Technology :

Last Reviewed: April 5, 2000 © 2000 Microsoft Corporation. All rights reserved. Terms of Use.