I have used the Search option but can't find it.

Where does it lie by default?

Thanks

Hi Simon

See
http://www.rondebruin.nl/personal.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Simon" wrote in message ...
I have used the Search option but can't find it.

Where does it lie by default?

Thanks

Press ALT-F11 to go to the vb editor. If you see personal.xls there you
have one. Add the following to a module in it and run it:

sub whereamI()
msgbox thisworkbook.fullname
end sub

Robert Flanagan
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

"Simon" wrote in message
...
I have used the Search option but can't find it.

Where does it lie by default?

Thanks