where are macros held?

H

harry

Someone left our office. I know he has some macros in his spreadsheet e.g.
it sorts data when you switch worksheets and his manager says they must be
there. In Tools/Macro/Macros is empty - where else could they be? Thanks
 
B

Bob Phillips

Go into the VBE (Alt-F11), make sure the project explorer is up (Ctrl-R),
select your workbook, make sure it is fully expanded (+/- sign), make sure
the Microsoft Excel Objects is fully expanded (+/- sign) and click
THisWorkbook. The code should be in there. If it is not, select the
worksheet that gets sorted. It will be there.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top