protecting hidden rows

  • Thread starter Thread starter Randy Starkey
  • Start date Start date
R

Randy Starkey

Hi,

What is the easiest way to password protect hidden rows, where one user can
get tot hem easily, but not others? Excel 2003 on WinXP Pro.

Thanks!

--Randy Starkey
 
Password protect the worksheet.

The "one user" would have the password to unprotect.

Note: Excel's internal security is very weak and passwords easily cracked.

Anyone who could access the internet or these news groups could find a way to
unprotect the sheet.

If you don't want anyone to see data in an Excel workbook or worksheet, do not
include that data.


Gord Dibben MS Excel MVP
 
Gord,

OK. It's mild security needed for non-techs so that should work fine. Thing
is though, I need all users to still be able to enter data in the visible
cells. Can I do that? I tried this once and it seemed protecting the sheet
stopped data entry. I may not have selected enough options? What should I
check and uncheck? I'll go experiment some more. Thanks!

--Randy Starkey
 
If you want to allow data entry then you should unlock those cells
first. Select the cells, then click on Format | Cells | Protection tab
and unclick Locked. Now when you apply password protection to the
sheet through Tools | Protection etc those cells will still allow
changes to be made.

Hope this helps.

Pete
 
Back
Top