 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / February 2008protecting hidden rows
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 >Hi, > [quoted text clipped - 4 lines] > >--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 > Password protect the worksheet. > [quoted text clipped - 21 lines] >> >>--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 On Feb 27, 2:20 am, "Randy Starkey" <randy.starkeyNOS...@NOSPAMvictorychurch.com> wrote: > Gord, > [quoted text clipped - 33 lines] > > - Show quoted text - See Pete's reply about unlocking entry cells before protecting the sheet. Gord >Gord, > [quoted text clipped - 31 lines] >>> >>>--Randy Starkey |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.