Preventing other users from opening hidden worksheets

  • Thread starter Thread starter pjk@boro
  • Start date Start date
P

pjk@boro

I have a workbook to which only i have the password. All other users open it
as "read only". Within the book are some hidden worksheets. However, even
when the book is opened as "read only", a user is able to unhide these
sheets. I've tried using "Tools-Options-View-Hide Tabs" &
"Format-Sheet-Hide", all to no avail.
Is there an easy way I can prevent this?
thanks in anticipation.
 
Hi

Open VBA Editor (Ctrl+F11). Usually there will be VBA-Project Explorer
window, Properties window (both at left), and Code window (at right) opened.
When Properties window is closed, you can open it from View menu (Excel
2000).

In VBA Project window, select the sheet, you want to hide, and in Properties
window, set it's Visible property to xlSheetVeryHidden. Now the user can
make this sheet visible only from VBA-Project Properties window.

To prevent users meddle with VBA Project Properties too, right-click on your
VBA project in Project window (the object with your workbook name is
brackets), select VBA Project properties from drop-down, activate Protection
tab, check 'Lock Project from viewing', and set password.

(Store the password somewhere, or you may have some trouble later)
 
Protect the workbook under Tools>Protection>Protect Workbook.

After you have hidden the sheet, that would be.

See Bob's caveat about Excel security.


Gord Dibben MS Excel MVP
 
Back
Top