I have a button on a spreadsheet that accesses performs the "ShowAll"
function of:

ActiveSheet.ShowAllData

It works great unless all the data is present, of course. Rather than get
the 1004 error of:

"Run-time error '1004':

ShowAllData method of Worksheet class failed"

what can I add to the line of coding above, ActiveSheet.ShowAllData, to
alert the user that all the data is showing?

Thanks.