| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lock Cell status
Is there any way in Excel to see the status of a cell whether it is Locked or
Unlocked when we move the cursor across the sheet? Can Excel prompt "Locked" or "Unlocked" ? Thanks, SUNAN. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Lock Cell status
Not without using VBA.
Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Cells.Count 1 Then Exit Sub End If MsgBox "Cell Locked: " & Target.Locked End Sub Right click the worksheet tab, choose View Code and paste the above code in to that code module. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "sunan" wrote in message ... Is there any way in Excel to see the status of a cell whether it is Locked or Unlocked when we move the cursor across the sheet? Can Excel prompt "Locked" or "Unlocked" ? Thanks, SUNAN. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Lock Cell status
Thanks Chip,
Does that mean Locked Cell has a value =1 ? What value is that actually? SUNAN "Chip Pearson" wrote: Not without using VBA. Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Cells.Count 1 Then Exit Sub End If MsgBox "Cell Locked: " & Target.Locked End Sub Right click the worksheet tab, choose View Code and paste the above code in to that code module. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "sunan" wrote in message ... Is there any way in Excel to see the status of a cell whether it is Locked or Unlocked when we move the cursor across the sheet? Can Excel prompt "Locked" or "Unlocked" ? Thanks, SUNAN. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Lock Cell status
Sunan,
The Locked property returns a Boolean value of True or False. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "sunan" wrote in message ... Thanks Chip, Does that mean Locked Cell has a value =1 ? What value is that actually? SUNAN "Chip Pearson" wrote: Not without using VBA. Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Cells.Count 1 Then Exit Sub End If MsgBox "Cell Locked: " & Target.Locked End Sub Right click the worksheet tab, choose View Code and paste the above code in to that code module. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "sunan" wrote in message ... Is there any way in Excel to see the status of a cell whether it is Locked or Unlocked when we move the cursor across the sheet? Can Excel prompt "Locked" or "Unlocked" ? Thanks, SUNAN. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Instead of a negative number, I'd like to show zero... | Excel Worksheet Functions | |||
| how can i lock cell immediately if any value Entered? | New Users to Excel | |||
| cell color index comparison | New Users to Excel | |||
| Cell lock | Excel Worksheet Functions | |||
| lock a picture to a cell so i can mail merge | Excel Worksheet Functions | |||
Linear Mode
