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
"Dave F" wrote in message
oups.com...
I know my way around the VBE; there are no modules visible or code
visible in any of the sheets.

On Aug 20, 11:22 am, "Zone" wrote:
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" wrote in message

ps.com...



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

On Aug 20, 10:46 am, "Bob Umlas" wrote:
see if there's a defined name called auto_open or auto_close

"Dave F" wrote in message

groups.com...

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.- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -