 |
 | 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 / January 2007Is there any way to make unlocked cells visible when the sheet is locked?
Is there any way to make unlocked cells visible when the sheet is locked? Bart XP/Ex 2003 Is there any way to MARK unlocked cells visible when the sheet is locked? > Is there any way to make unlocked cells visible when the sheet is > locked? > > Bart > > XP/Ex 2003 One way if you're not using format|conditional formatting, you could select the cells (all of them???) and with A1 the the activecell: Format|conditional formatting formula is: =cell("protect",a1) Give it a nice format. > Is there any way to make unlocked cells visible when the sheet is > locked? > > Bart > > XP/Ex 2003  SignatureDave Peterson It goes in the right directed, i guess. how to cond format the cells who are not locked. The idea is that other people should know in which cells they have to fill in a value, namely on the unlocked cells. The sheet is protected. And, the marks of the unlocked cells (given by conditional formatting?) should not be printed, while other formats has. How to perform? > One way if you're not using format|conditional formatting, you could select > the cells (all of them???) and with A1 the the activecell: [quoted text clipped - 13 lines] > > Dave Peterson You can use: =CELL("protect",A1)=0 to highlight the cells that are unlocked. To keep from printing those shades, you can pick out a cell to use as an indicator. I used $A$1 because it's usually easy to find and modify. Use a conditional formatting formula of: =AND($A$1<>"",CELL("protect",A1)=0) And to see the shading, put something in A1. To hide the shading, erase the contents of A1. > It goes in the right directed, i guess. > how to cond format the cells who are not locked. The idea is that [quoted text clipped - 22 lines] > > > > Dave Peterson SignatureDave Peterson |
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.