can hidden sheets be prevented from opening without a password?

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?
 
N

Nicholas Perkins

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Protecting Word 2019 document 0
Password protect new workbooks from template 0
How can the font and size of (all) citation numbers be altered? 1
protecing hidden columns 1
How to remove a bracket that is itallicised for an entire document 1
Merging from an Excel file with graphics 1
Userinterfaceonly 5
Table Security in Access 2013 1

Top