C
charles osborne
I made a macro that clicks a button on one sheet to go to
another sheet, then clicks on a cell, then clicks Data>Form.
After making the macro, when I click the button on sheet
one, the macro takes me to sheet two and then gives me an
error message.
The error I get is:
1"Runtime error 1004
ShowDataForm method of Worksheet class failed."
When I run the debug 3 lines show with the last line being
highlighted. It reads: ActiveSheet.ShowData Form
Any help is appreciated.
~~Charles Osborne
another sheet, then clicks on a cell, then clicks Data>Form.
After making the macro, when I click the button on sheet
one, the macro takes me to sheet two and then gives me an
error message.
The error I get is:
1"Runtime error 1004
ShowDataForm method of Worksheet class failed."
When I run the debug 3 lines show with the last line being
highlighted. It reads: ActiveSheet.ShowData Form
Any help is appreciated.
~~Charles Osborne