Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel file opens with a blank screen | Excel Discussion (Misc queries) | |||
Automatically update from source when file opens | Excel Discussion (Misc queries) | |||
When I open an Excel file attached to an email, it opens as read-. | Excel Discussion (Misc queries) | |||
Excel 2003 Opens Up Every File in My Documents | Excel Discussion (Misc queries) | |||
Password error after file opens | Excel Worksheet Functions |