LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 53
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Position Cursor to same address on another tab SassyLassie Excel Worksheet Functions 0 July 14th 06 05:44 AM
Position of cursor when protected file is opened Stilla Excel Worksheet Functions 3 December 8th 05 07:16 PM
Be able to edit position of datalabels in a protected chart. Joy Excel Programming 2 June 13th 05 08:21 PM
be able to edit datalabel position of all series in a protected ch Joy Excel Programming 2 June 13th 05 05:31 PM
Address returned, Not Contents? MJSlattery Excel Discussion (Misc queries) 0 November 25th 04 11:11 PM


All times are GMT +1. The time now is 06:37 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"