Microsoft KB Archive/162320

{|
 * width="100%"|

XL97: Excel Articles Available by E-Mail: VBA

 * }

Q162320

-

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://www.microsoft.com/support"

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: [mailto:mshelp@microsoft.com 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:

"[mailto:mshelp@microsoft.com mshelp@microsoft.com]"

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 XL: How to Save Personal Macro Workbook When 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 File Names

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 OFF97: 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 kbdta

Issue type : kbinfo

Technology :