Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Bertha Ferguson   on Jan 14 In MS Office Category.

  
Question Answered By: Cais Nguyen   on Jan 14

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.

Share: 

 

This Question has 11 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on user form with search criteria Or get search suggestion and latest updates.


Tagged: