The information in this article applies to:
SYMPTOMSWhen you copy a dialog sheet, the new dialog sheet contains row and column headers similar to those displayed in worksheets and Microsoft Excel 4.0 macro sheets. CAUSE
This problem occurs when the following conditions are true:
-and- WORKAROUND
If you want to create a copy of a dialog sheet and you don't want it
to contain row and column headers, make sure that the first window of
the workbook is the active window when you copy the dialog sheet. STATUSMicrosoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. This problem no longer occurs in Microsoft Excel 2000. MORE INFORMATION
If you create a copy of a dialog sheet and it contains row and column
headers because the conditions described earlier are true, there is no way
to remove the row and column headers from the new dialog sheet. When a
dialog sheet is active, the "Row & Column Headers" option on the View tab
in the Options dialog box is unavailable. Additional query words: 97 7.00a 5.00a 5.00c dialogsheet custom headings XL97 XL7 XL5
Keywords : kbdta |
Last Reviewed: November 5, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |