I have used the Search option but can't find it. Where does it lie by default? Thanks
S Simon Dec 9, 2009 #1 I have used the Search option but can't find it. Where does it lie by default? Thanks
R Robert Flanagan Dec 9, 2009 #3 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
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
