can't find macros in a macro-enabled workbook

[Dave F]

I received a workbook from a colleague that apparently has macros.
However when I go into the VBE I don't see any code in any of the
worksheets, and I don't see any modules. Is there a way to hide
macros? If so how would I unhide them?

Thanks.

 

[Guest]

The macros could be part of the Microsoft Excel Objects, for example, they
could be part of Sheet1 or part of the "ThisWorkbook" object.
So when you open your Visual Basic Editor they don't appear in a module.
Double click on the Object and on the left side of your editor you should see
the dropdown boxes where the code maybe, switch them one by one to find what
you are looking for.

 

[Bob Umlas]

see if there's a defined name called auto_open or auto_close

 

[Dave F]

I don't see defined names auto_open or auto_close....

 

[Zone]

Dave, when you are in the VBE, you should see the project explorer as a
tall, narrow window on the left. If not, press Ctr-r to show it. In the
list, find the name of the file showing as
VBAProject (NameOfFile.xls)
There will be a box to the left of it with a + in it. Click on the plus
sign. Now you should see a list of things under there. See Modules? See
Microsoft Excel Objects? Click on the + to the left of these things. Now
you should see lists of things under these things. Click on each thing in
turn to see what's in it. If you're asked for a password at any time while
looking through these things, the code is protected from view and you'll
need the password.
HTH, James

 

[Dave F]

I know my way around the VBE; there are no modules visible or code
visible in any of the sheets.

 

[Zone]

Hmmm, if any other workbooks opened with the file, they should be listed in
the project explorer, as well. Maybe someone else has an idea. James