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