Start with the search window open

[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

 

[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

 

[Guest]

Frank,

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

Thanks

 

[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.