Hi all, how do I change this to having the word 'greyscale' by default in the cell and rest stays the same (so click on it and it will change to 'bitmap' and click again to get 'greyscale')?
If Not Intersect(Target, Range("N3:N25000")) Is Nothing Then
If Target.Count > 1 Then Exit Sub
If Target.Value = "Greyscale" Then Target.Value = "Color" Else: Target.Value = "Greyscale"
End If
Bookmarks