Start with the search window open

J

joseph

I have a spreedsheet that when it opens,I'd like it to
open with the search window (Find Control F) open. Any
help appreciated.

Thanks
Joseph
 
F

Frank Kabel

Hi
put the following code in your workbook_open event (this goes in your
workbook module not in a standard module):
sub workbook_open()
application.Dialogs(xlDialogFormulaFind).Show
end sub
 
G

Guest

Frank,

Thank you for the help, but can you direct me as to how
do I access the workbook module?

Thanks
 
D

Dave Peterson

Open excel.
Open your workbook
make the worksheet window full screen
right click on the excel icon to the left of the worksheet menu bar (the one
with file|edit|View, etc on it)

Select view code.

And you're there.
 
Top