How to Hide Document Properties

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

Hello,

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.

Regards
David

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

David
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 it....select Visible property
dropdown options.

Ivan