Run macro only in certain range double clicked

[johnohio]

I have a spreadsheet where the sheet that is locked and if the user double clicks in a certain column I would like a macro to run.

for example..
there are 100 rows, hers are 3 of them...

if the user double clicks on on the first column a macro will run, double click on any other cell nothing happens.
The spreadsheet needs to be locked so the user cannot edit.


Thanks everyone

 

[Micron]

Like this?

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)

If Not Target.Column = 1 Then
   Cancel = True
   Exit Sub
End If

msgbox "Column 1 was double clicked"
Cancel = True 'may need this to suppress message re: changing protected sheet

End Sub

 

[johnohio]

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) If Not Target.Column = 1 Then Cancel = True Exit Sub End If msgbox "Column 1 was double clicked" Cancel = True 'may need this to suppress message re: changing protected sheet End Sub

That does not work because the worksheet is locked.

 

[Joe4]

That does not work because the worksheet is locked.

Just add a line of VBA code to unprotect it, make the change, and then re-protect it.
See: VBA Protect / Unprotect Worksheets - Automate Excel

 

[Micron]

I protected the sheet but allowed user to select locked and unlocked cells. Perhaps you didn't have those settings? I'm rusty, but I thought that setting allowed users to do that but still not make changes.