| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How To Find If The ActiveCell Is Protected
What would be the appropriate code for finding whether the active cell is
locked and protected? Run-time error '438': Object doesn't support this property or method is being returned on the following piece: If ActiveCell.Protected = True Then MsgBox ("You can't change the contents of this Cell. It is locked & protected.") Help from you experts is sought! Thanx in advance. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How To Find If The ActiveCell Is Protected
Try
If ActiveCell.Locked = True Then MsgBox ("You can't change the contents of this Cell. It is locked & protected.") End If -- Pl click the ''''Yes'''' button (if you see it - don''''t worry if you don''''t), if this answer was helpful. "FARAZ QURESHI" wrote: What would be the appropriate code for finding whether the active cell is locked and protected? Run-time error '438': Object doesn't support this property or method is being returned on the following piece: If ActiveCell.Protected = True Then MsgBox ("You can't change the contents of this Cell. It is locked & protected.") Help from you experts is sought! Thanx in advance. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How To Find If The ActiveCell Is Protected
Try Activecell.Locked
If this post helps click Yes --------------- Jacob Skaria "FARAZ QURESHI" wrote: What would be the appropriate code for finding whether the active cell is locked and protected? Run-time error '438': Object doesn't support this property or method is being returned on the following piece: If ActiveCell.Protected = True Then MsgBox ("You can't change the contents of this Cell. It is locked & protected.") Help from you experts is sought! Thanx in advance. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How To Find If The ActiveCell Is Protected
Already tried! But Protection and locking is different. All the cells are
locked by default and the code won't proceed whether the sheet/cell is protected or not. "Sheeloo" wrote: Try If ActiveCell.Locked = True Then MsgBox ("You can't change the contents of this Cell. It is locked & protected.") End If -- Pl click the ''''Yes'''' button (if you see it - don''''t worry if you don''''t), if this answer was helpful. "FARAZ QURESHI" wrote: What would be the appropriate code for finding whether the active cell is locked and protected? Run-time error '438': Object doesn't support this property or method is being returned on the following piece: If ActiveCell.Protected = True Then MsgBox ("You can't change the contents of this Cell. It is locked & protected.") Help from you experts is sought! Thanx in advance. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How To Find If The ActiveCell Is Protected
Protection and locking is different. All the cells are locked by default and
the code won't proceed whether the sheet/cell is protected or not. "Jacob Skaria" wrote: Try Activecell.Locked If this post helps click Yes --------------- Jacob Skaria "FARAZ QURESHI" wrote: What would be the appropriate code for finding whether the active cell is locked and protected? Run-time error '438': Object doesn't support this property or method is being returned on the following piece: If ActiveCell.Protected = True Then MsgBox ("You can't change the contents of this Cell. It is locked & protected.") Help from you experts is sought! Thanx in advance. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How To Find If The ActiveCell Is Protected
Found It!
Correct code would be: If ActiveSheet.ProtectContents = True And ActiveCell.Locked = True Then MsgBox ("Cell Is Locked & Worksheet Is Protected.") End If "FARAZ QURESHI" wrote: Already tried! But Protection and locking is different. All the cells are locked by default and the code won't proceed whether the sheet/cell is protected or not. "Sheeloo" wrote: Try If ActiveCell.Locked = True Then MsgBox ("You can't change the contents of this Cell. It is locked & protected.") End If -- Pl click the ''''Yes'''' button (if you see it - don''''t worry if you don''''t), if this answer was helpful. "FARAZ QURESHI" wrote: What would be the appropriate code for finding whether the active cell is locked and protected? Run-time error '438': Object doesn't support this property or method is being returned on the following piece: If ActiveCell.Protected = True Then MsgBox ("You can't change the contents of this Cell. It is locked & protected.") Help from you experts is sought! Thanx in advance. |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How To Find If The ActiveCell Is Protected
Found It!
Correct code would be: If ActiveSheet.ProtectContents = True And ActiveCell.Locked = True Then MsgBox ("Cell Is Locked & Worksheet Is Protected.") End If "Jacob Skaria" wrote: Try Activecell.Locked If this post helps click Yes --------------- Jacob Skaria "FARAZ QURESHI" wrote: What would be the appropriate code for finding whether the active cell is locked and protected? Run-time error '438': Object doesn't support this property or method is being returned on the following piece: If ActiveCell.Protected = True Then MsgBox ("You can't change the contents of this Cell. It is locked & protected.") Help from you experts is sought! Thanx in advance. |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How To Find If The ActiveCell Is Protected
Thanks...
"FARAZ QURESHI" wrote: Found It! Correct code would be: If ActiveSheet.ProtectContents = True And ActiveCell.Locked = True Then MsgBox ("Cell Is Locked & Worksheet Is Protected.") End If "FARAZ QURESHI" wrote: Already tried! But Protection and locking is different. All the cells are locked by default and the code won't proceed whether the sheet/cell is protected or not. "Sheeloo" wrote: Try If ActiveCell.Locked = True Then MsgBox ("You can't change the contents of this Cell. It is locked & protected.") End If -- Pl click the ''''Yes'''' button (if you see it - don''''t worry if you don''''t), if this answer was helpful. "FARAZ QURESHI" wrote: What would be the appropriate code for finding whether the active cell is locked and protected? Run-time error '438': Object doesn't support this property or method is being returned on the following piece: If ActiveCell.Protected = True Then MsgBox ("You can't change the contents of this Cell. It is locked & protected.") Help from you experts is sought! Thanx in advance. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If activecell.column = variable then activecell,offset (0,1) | Excel Discussion (Misc queries) | |||
| Find text in a protected worksheet | Excel Discussion (Misc queries) | |||
| Find text in a protected worksheet | Excel Discussion (Misc queries) | |||
| Using FIND on a protected worksheet | Excel Worksheet Functions | |||
| Find Protected Cells Q | Excel Worksheet Functions | |||
Linear Mode
