Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find Protected Cells
I know that I can lock cells and hide their formulas.
Selection.Locked = True Selection.FormulaHidden = True I also know that none of this kicks in unless the sheet itself is protected. ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True How do I tell if a cell is protected? What property am I tesing for? Is it first the sheet and then the cell? THanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How To Find If The ActiveCell Is Protected | Excel Discussion (Misc queries) | |||
Edit text format in non-protected cells in protected worksheet | Excel Discussion (Misc queries) | |||
How to "Find Next" text in protected cells | Excel Discussion (Misc queries) | |||
Find & Replace within Unlocked Cells in a Protected Worksheet | Excel Discussion (Misc queries) | |||
Find Protected Cells Q | Excel Worksheet Functions |