turn on/off the Private Sub Worksheet_SelectionChange(ByVal target As Range)

[zrx1200]

I wish to turn on and off the
above "title" item. Currently I just use the comment 'tilde which allows me t edit the sheet without firing code. I tried recoded macro but it is not reliable has issues, seems t lock you out/down or the like.

 

[patel45]

You can reserve a cell i.e. Z1 for a flag, then

Sub Worksheet_SelectionChange(ByVal target As Range)
If range("Z1") <>"" then exit sub
' put here your code
..............
end sub

 

[zrx1200]

You can reserve a cell i.e. Z1 for a flag, then

Sub Worksheet_SelectionChange(ByVal target As Range)
If range("Z1") <>"" then exit sub
' put here your code
..............
end sub

Awesome, great idea! Thanks.