I have recorded two macros and attached them to buttons on the sheet. The first macro is for an advanced filter in place and the second is to show all the data again.
If someone clicks on the restore button BEFORE running the advanced filter the Microsoft Visual Basic box opens with runtime error '1004' displayed and the message "ShowAllData method of Worksheet class failed" and displaying three active buttons 'End', 'Debug' and 'Help"
The macro code is:
Sub Restore()
ActiveSheet.ShowAllData
End Sub
I would like a warning box to pop up on clicking the Restore button BEFORE running the filter to say
"you MUST click on the SEARCH button BEFORE clicking on the RESTORE button"
Any help gratefully received!
If someone clicks on the restore button BEFORE running the advanced filter the Microsoft Visual Basic box opens with runtime error '1004' displayed and the message "ShowAllData method of Worksheet class failed" and displaying three active buttons 'End', 'Debug' and 'Help"
The macro code is:
Sub Restore()
ActiveSheet.ShowAllData
End Sub
I would like a warning box to pop up on clicking the Restore button BEFORE running the filter to say
"you MUST click on the SEARCH button BEFORE clicking on the RESTORE button"
Any help gratefully received!