Hide button on worksheet if there is nothing contained in cell E24

[TheJay]

I've written some code but it's not working and I am not sure why.

Private Sub Worksheet_Change(ByVal Target As Range)
    Application.ScreenUpdating = False
    If Cells(5, 24).Value <> "1" Then
        ActiveSheet.Shapes("Button412").Visible = True
        Else
        ActiveSheet.Shapes("Button412").Visible = False
    End If
    Application.ScreenUpdating = True
End Sub

I want to make sure the button is hidden when the sheet is opened and only when a value appears in E24 should the button appear.

Could someone please point out my mistake and how to fix it?

 

[TheJay]

Thanks for confirming.

Google Drive: Sign-in

 

[mumps]

Your link takes me to the sign-in screen. I need a direct link to your file.

 

[TheJay]

Sorry, copied the link as usual.

ME.xlsm

Tracker Work Tracker Task,Start Time,Finish Time,Time Test,14:19,

docs.google.com

 

[mumps]

The problem is that the formula in E24 returns a value in hours and minutes which will never equal "1". Can you explain in more detail what time has to be displayed in E24 so that the button is hidden?

 

[TheJay]

The problem is that the formula in E24 returns a value in hours and minutes which will never equal "1". Can you explain in more detail what time has to be displayed in E24 so that the button is hidden?

Thanks for your reply. It could be any amount of time between a minute and 24 hours for example.

H:MM

 

[mumps]

So if any time is displayed in E24, you want the button hidden and if E24 is blank, you want the button visible. Is this correct?