[dba-Tech] Excel protection question

Here's a possibility. Say cell B2 in some worksheet is the linked cell. Then this code would move the focus out of that cell any time it reaches there...

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
With ActiveWindow
        If Target.Address = "$B$2" Then
            SendKeys "{Tab}"
        End If
    End With
End Sub 

HTH

Lambert

-----Original Message-----
From: dba-tech-bounces at databaseadvisors.com [mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
Sent: Tuesday, August 31, 2010 8:06 PM
To: Discussion of Hardware and Software issues
Subject: [dba-Tech] Excel protection question

I've run into a peculiar problem with an Excel sheet. I'm using Forms option buttons in a group box -- in a protected sheet. Unfortunately, if I don't unlock the linked cell (linked to the option buttons), I can't click the option buttons themselves. 

Okay, so I unlock the linked cell, but then, in protect mode, Excel selects that cell. I don't want to select that cell -- I want Excel to select the first cell in an input range and ignore that I've unlocked that linked cell. 

Any advice? 

Susan H. 
_______________________________________________
dba-Tech mailing list
dba-Tech at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-tech
Website: http://www.databaseadvisors.com