where are macros held?

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

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)


"harry" <harry.bosch@fsnet.com> wrote in message
news:crc0gd$jsf$1@titan.btinternet.com...
> 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
>
>

Open the worksheet and click on Tools / Macro, which then offers a menu: Macro; Record New Macro; Visual Basic Editor. Click on Macro and a panel opens to reveal any saved macro's. More on Macro's here: http://support.microsoft.com/?kbid=209214