Search tool for Excel workbooks

[ryuji4000]

I've created a workbook in Excel 2000 with multiple pages. The first
page consists of hyperlinks to data on other worksheets. I would like
to be able to search the entire workbook for specific data, and add
this as a tool on the first page of the workbook. Can this be done?
Will I need to dload some add-ins for excel for this? Trying to make
this as simple as possible without making the recipients of this
workbook install any add-ins. Any help would be much appreciated.

Thanx,

Ryuji4000

 

[Dave Peterson]

You may like to try Jan Karel Pieterse's FlexFind at:
http://www.bmsltd.co.uk/MVP/Default.htm

He has a lot of nice options in it. It's an addin. It builds its own toolbar
and can be used against any open workbook. So it's not quite what you asked,
but maybe nicer that you thought possible.

In xl2k, you can select the sheets you want to search through and then do your
find (edit|Find).