can hidden sheets be prevented from opening without a password?

  • Thread starter Thread starter unclepablo54
  • Start date Start date
U

unclepablo54

I want to prevent a worksheet being viewed by other users of the workbook.
Can this be done by, say, password protection, as can be done in Word?
 
Hi unclepablo54,

It certainly can.

In Excel 2007, you would first hide the sheets that you want to remain
hidden. Then click "Protect Workbook" from the "Review" section of the
ribbon. You click on "Protect the Structure and Windows" and leave "Windows"
ticked. Enter your password and your workbook is protected.

Users cannot unhide the sheets without the password.

I hope this helps.

Cheers,
Nick


--
Nicholas Perkins
Excel Analyst, Designer and Programmer
http://www.nicholasperkins.com/
(e-mail address removed) bad.com
(Please remove the spamisbad)
 
Back
Top