Auto Search When File Opens
 

Is there a way to configure a spreadsheet so it automatically comes up with
the FIND tool as soon as the sheet opens?

Thanks,
Mark

Is there a specific group of text that you want to find? A macro could be
written to find it. Otherwise, try CONTROL F.

"markmidwest" wrote:

Is there a way to configure a spreadsheet so it automatically comes up with
the FIND tool as soon as the sheet opens?

Thanks,
Mark

You can have a macro run each time that the workbook opens:

Option Explicit
Sub auto_open()

Worksheets("sheet1").Select 'open to the correct sheet
Application.Dialogs(xlDialogFormulaFind).Show

End Sub


If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

markmidwest wrote:

Is there a way to configure a spreadsheet so it automatically comes up with
the FIND tool as soon as the sheet opens?

Thanks,
Mark

--

Dave Peterson

CTRL/F is exactly what I need but I woud like it to start as soon as the
spreadsheet opens. There are 5000+ names in the sheet & it a search will be
necessary so having it open automatically will save them a small step.

Thanks,
Mark

"Barb R." wrote:

Is there a specific group of text that you want to find? A macro could be
written to find it. Otherwise, try CONTROL F.

"markmidwest" wrote:

Is there a way to configure a spreadsheet so it automatically comes up with
the FIND tool as soon as the sheet opens?

Thanks,
Mark