Require Password to View Worksheet

  • Thread starter Thread starter Marc C
  • Start date Start date
M

Marc C

I have a workbook with 12 worksheets. One of them contains data that i
not for all to see. I'd like to require a password to view this on
worksheet while leaving the remaining sheets open to all. Right now I'
just hiding it, but I'd like to make it more secure. Any ideas? Thanks
 
If you protect the windows structure (tools|protect workbook), then that
worksheet can't be shown (until the workbook is unprotected).

The bad news is that there is code posted every day to do just that.

If you really want to protect the info on that worksheet--don't share it.
 
The problem with hide and protect is that you only have to copy and paste the worksheet to a new workbook and the entire contents are then available for all to see - I guess the only surefire way to protect the data is to put it in a linked book and password the book
 
You must log in or register to reply here.

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

Password protect from viewing 2
Need to merge worksheets - Excel 2003 0
password protect a sheet 5
Prevent worksheet selection 2
hide, unhide column or row after protect worksheet 4
Protect Multiple Worksheets from view before password 1
Security & password protection 1
Security for excel worksheet 1

Back
Top