How would you write an "IF" statement based on if a macro button exists on the spreadsheet? I'm planning to delete the button once the user clicks on it but I need to take care of the scenario if the user tries to type data into cells before clicking on that macro button.
So basically just need help on if the button exists. Would it be something like this:
If ActiveSheet.Buttons("Auto Save") <> 0 Then
Range("A5:A10").Value = ""
MsgBox "Click Auto Save Button." & vbNewLine & _
vbNewLine & "Then You May Start Entering Data."
Application.EnableEvents = True
Exit Sub
End If
So basically just need help on if the button exists. Would it be something like this:
If ActiveSheet.Buttons("Auto Save") <> 0 Then
Range("A5:A10").Value = ""
MsgBox "Click Auto Save Button." & vbNewLine & _
vbNewLine & "Then You May Start Entering Data."
Application.EnableEvents = True
Exit Sub
End If