Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Returned position address on protected sheet
I have a protected sheet with unprotected cells. If the user Click on a protected cell, the returned target is always the first unlock cell position or address. How can I verify that the target value is lock? Here is the code:
Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Not Intersect(Target, Range("E1:F" & lastrow)) Is Nothing Then something..... End If End Sub Thank's ahead |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Position Cursor to same address on another tab | Excel Worksheet Functions | |||
Position of cursor when protected file is opened | Excel Worksheet Functions | |||
Be able to edit position of datalabels in a protected chart. | Excel Programming | |||
be able to edit datalabel position of all series in a protected ch | Excel Programming | |||
Address returned, Not Contents? | Excel Discussion (Misc queries) |