protecting hidden rows

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
 
G

Gord Dibben

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
 
R

Randy Starkey

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
 
P

Pete_UK

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
 
Top