how can you see the locked cells

[bluebellsix]

if i have a sheet with locked cells is there anyway i can see them like the Find command where you can highlight cells which have no formulas or formulas thanks

 

[Dannyh1]

Hi - do you know the password?

Could try this if so:

Sub Noformula()
 
Dim rng As Range
Dim cl As Range
 
Set rng = Range("A1:D100")
 
ActiveSheet.Unprotect Password:="[I]mypassword[/I]"

For Each cl In rng
 
If cl.Formula = "" Then
 
cl.Interior.ColorIndex = 6
 
End If
 
Next cl
 
ActiveSheet.Protect Password:="[I]mypassword[/I]"
 
End Sub

 

[bluebellsix]

yes have the password - i have been asked to show someone how they can tell what cells have been locked on a spreadsheet dont think your way is so user friendly i have suggested that they highlight the cells and colour them before they set the protection - but this is a sheet which has already had locked cells and they want to know how you can tell which ranges of cells but thanks for your reply

 

[Rick Rothstein]

if i have a sheet with locked cells is there anyway i can see them like the Find command where you can highlight cells which have no formulas or formulas thanks

You can use the Find command to do that as well. Select a range of cells to process (if you did not unlock all the cells before locking some of them, do not select all the cells... you will overwhelm your memory) and press CTRL+F to bring up the Find dialog box. Make sure the "Find what" field is empty, then click the "Options>>" button to reveal all the options. Click the Format button, select the "Protection" tab and put a check mark in the "Locked" checkbox and click OK to go back to the Find dialog box. Next click the "Find All" button and when the list is displayed in the table at the bottom of the dialog box, press CTRL+A to select them all. When you click the "Close" button, all locked cells will be selected. You can now do whatever you want with the selection (for example, color their interiors).