Hi all,
I am newbie with excel. Situation follows.
I have a workbook with two sheets, each sheet has around 60000
rows(part number) and 6 columns (various prices for coresponding part
number).
This is a price list imported from Access.

1. I need to protect workbook(read only) for distribution and provide
search option for entire workbook.
(i.e. search for part number and result should be entire row
highlighted for that part)

With ctrl-f default option is search "within a sheet" and I need
"within a workbook"as a default.
2. Should (and how) I create third sheet for search option and
results.

Please direct me where to look (books, www) and what to look for,
because I do not
find Excel help very helpfull.
Thanks in advance


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