You are right. I put this tiny code and it works "ActiveSheet.ShowDataForm".
That's very easy I see. But when I put a button on the start menu page which is
a different worksheet than where the data range is I get the run-time error
'1004'. It is obvious, no worksheet is indicated. Then I did some changes and it
looks like this:
Sub OpenSearchForm()
ActiveWorkbook.Sheets("´ÕÝìàÞÖÔÕÝØï").Activate
ActiveSheet.ShowDataForm
End Sub
It's good no problem. But I don't want the user to see the data range in order
to avoid accidental change of data. Is it possible to make the code open the
form without activating the worksheet.I know it is, but don't know how to make
it.