(Solved) – Active a macro by clicking in a cell with a formula?

  • by
(solved)-–-active-a-macro-by-clicking-in-a-cell-with-a-formula?

I am trying to activate a macro by clicking in a cell. I have the macro working if i click on an empty cell or a cell with general text in it. But I have a cell with an =’s formula in it and when i use the below code it does not activate the macro.

Option Explicit

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

If Selection.Count = 1 Then
    If Not Intersect(Target, Range("B37")) Is Nothing Then
        Worksheets("DaysEditor").Activate
        Sheets("DaysEditor").Columns("C:LY").Hidden = False
        Sheets("DaysEditor").Columns("C:EX").Hidden = True
        Sheets("DaysEditor").Range("A1").Select
    End If
End If
End Sub

This code works perfectly on a cell that doesn’t have a formula but will not work on cells with formulas in them. Please help me get this to work with a cell with a formula in it.

Leave a Reply

Your email address will not be published. Required fields are marked *