Mare,

I am not sure if we were looking for the same thing but here is a reply that
I received that took care of my problem/question.
================================================== ==

Hi Rick,
On Stephen Bullen's Excel MVP page
http://www.oaltd.co.uk/MVP/Default.htm

FindLink by Bill Manville would work
FlexFind by Jan Karel Pieterse would work better and is specifically
designed for Find

Selecting all of the sheets and doing Find may be helpful but it really does
not work. Aside from the danger of forgetting you selected all sheets and
could permanently damage your file as any change to what you see is done
to all the other sheets in the selection as well.
--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

================================================== =


"Mare" wrote:


Thanks Jon,

I did not explain that I need to distribute this workbook( price list )
to retailers, and what I need is when THEY press "ctrl-f", default
option should be "search within workbook" regardless of default setting
in Excel, which is "search within sheet".

If that is possible I would not have to explain to all of them, what
you have kindly explained to me.

"When you go to the Ctrl-F search dialog, click on the Replace tab and
OPTIONS - there is a pull-daown to select WORKBOOK instead of the
default option "Sheet" "

I hope this helps to understand my problem.

Thanks


--
Mare
------------------------------------------------------------------------
Mare's Profile: http://www.excelforum.com/member.php...o&userid=27644
View this thread: http://www.excelforum.com/showthread...hreadid=471672