How can I make the find dialog box appear as soon as I open a spr.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a spreadsheet that needs to be used down in the plant area where
people don't know very much about computers. I'm trying to make it easier
for them by letting them just have to open the spreadsheet through a shortcut
and then I'm hoping that I can just have the find dialog box pop up right
away without them doing anything so that they can just find what they are
looking for. It's a very large spreadsheet so it would be very helpful for
them to be able to do this. Is this possible?
 
You would need a macro for that it also means that they have to enable macros
when prompted, right click the excel icon next to the ftoolbar with file/
edit view etc
and select view code and paste in the following

Application.Dialogs(xlDialogFormulaFind).Show


press alt + q and save the workbook


Regards,

Peo sjoblom
 
Sorry, paste in this

Private Sub Workbook_Open()
Application.Dialogs(xlDialogFormulaFind).Show
End Sub


Regards,

Peo Sjoblom
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

open dialog box 1
I want a dialog box when opened 1
Adding more sort fields to the SORT Dialog Box 3
Navigate excel worksheet with find dialog box open 7
How can I make Excel display a message (dialog box) upon opening a spreadsheet? 8
Properties dialog box opens instead of a workbook 1
Open File Dialog box looks like 3
Retaining Sort order in the Sort Dialog box 2

Back
Top