Microsoft KB Archive/213692

= XL2000: Sheets Hidden with XlVeryHidden Can Be Viewed in Word =

Article ID: 213692

Article Last Modified on 1/24/2007

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition
 * Microsoft Word 97 Standard Edition

-



This article was previously published under Q213692





SYMPTOMS
If you open a Microsoft Excel 2000 workbook in Microsoft Word, a sheet that you hid by using the Visible property and the xlVeryHidden setting is unexpectedly available in the Open Workbook (Word 6.0) or Open Worksheet (Word 95, 97, 98) dialog box. If you open the sheet, you can view the data on the sheet.



CAUSE
This behavior occurs because the converter that Word uses to open Excel workbooks ignores any settings that you specify for the Visible property of a sheet in a Microsoft Visual Basic for Applications macro.



WORKAROUND
Other than making the workbook an add-in, you cannot hide worksheets so that they cannot be viewed in Word. However, you can place a password on the Excel file so that you cannot open the file in Word or Excel without typing the password.

To place a password on an Excel file, follow these steps:
 * 1) On the File menu, click Save As.
 * 2) In the Save As dialog box, click the destination folder for the file, enter a name for the file, and then click Options.
 * 3) In the Save Options dialog box in Excel 2000, type a password in the Password To Open box.
 * 4) Click OK.
 * 5) Retype the password in the Confirm Password dialog box, and then click OK.
 * 6) Click Save.

