I have a sheet with a table of data -- the headings are in B10:Z10, and the data start on B11:Z11, and Data Filter is on.
When I manually select cell B10 and pull down Data/Form, it works (I have no "custom form"). But if I record a macro with those two actions (select B10, open the Data Form), it fails at Application.ShowDataForm! All it says is the method failed.
I also find that if the sheet is protected, even if the whole range of data is unlocked, the Data Form shows blanks. You can put stuff in, and it will replace what's in cells B11:Z11 down, but on the Data Form there are blanks.
What's going on??
When I manually select cell B10 and pull down Data/Form, it works (I have no "custom form"). But if I record a macro with those two actions (select B10, open the Data Form), it fails at Application.ShowDataForm! All it says is the method failed.
I also find that if the sheet is protected, even if the whole range of data is unlocked, the Data Form shows blanks. You can put stuff in, and it will replace what's in cells B11:Z11 down, but on the Data Form there are blanks.
What's going on??
