I am a newbie to this board as well as a Novice to Excel. With that being said I have a question about locked (protected) sheets. I have simple sheet that has 12 colums, of these 5 of them have formulas that I need to protect from the end user. The end user would like the ability to fill (color) a row once that row is completed. Is there a way to have the sheet locked and still have the ability to color fill the row? Once it sheet is locked the color fill is greyed out. Thanks!
If you look at Review tab > Changes group > Protect sheet, you'll find the dialog box has a lot of tick options, including one to allow the user to format cells. Tick that one, and they should be able to change the colour even if the cell is protected.
Kind Regards,
Out of the Hat
"Computers are stupid - they do EXACTLY what you tell them to"
If I've helped you with a problem, please say thanks by clicking the small star icon on the left.
Thank you, that works perfect
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks