where are macros held?

  • Thread starter Thread starter harry
  • Start date Start date
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
 
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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Search OF Macros for a specific phrase 2
sending a macro to another person 1
writing a sort macro 2
password protection problem 2
Outlook Lost Pst Files 2
Resetting up Excel 2003. Is there a fast simple way to re-associatemacros with macro buttons? 1
excel 7 and excel 2003 3
Counting multiple memberships 1

Back
Top