MrExcel Publishing
Your One Stop for Excel Tips & Solutions

How to Hide Document Properties

Posted by David Holstein on January 16, 2000 3:34 PM


When you right click on a closed Excel file and select properties you can view the "Worksheet Names" inside the file via the Contents tab.

Is there are way to disable this feature or hide it from prying eyes. Thanks in advance.


Posted by Ivan Moala on January 17, 2000 2:22 AM

Not sure about a disable feature fro this But...
you can in the vba editor set the sheets(except 1)
to xlsheetveryhidden. The sheet that you do have visible
just rename it to " " a balnk space it will not show up.
In VBA editor = Alt F11 then F4 = properties
Then in the Project explorer select the sheet by
double clicking on Visible property
dropdown options.