can hidden sheets be prevented from opening without a password?
 

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?

can hidden sheets be prevented from opening without a password?
 

Yes.
Hide the sheet, then Tools/ Protection/ Workbook
--
David Biddulph

"unclepablo54" wrote in message
...
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?

can hidden sheets be prevented from opening without a password?
 

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/
is bad.com
(Please remove the spamisbad)



"unclepablo54" wrote:

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?