can't find macros in a macro-enabled workbook
 

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.

can't find macros in a macro-enabled workbook
 

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.

--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.




"Dave F" wrote:

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.

can't find macros in a macro-enabled workbook
 

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

"Dave F" wrote in message
oups.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.

can't find macros in a macro-enabled workbook
 

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

oups.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 -

can't find macros in a macro-enabled workbook
 

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

oups.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 -

can't find macros in a macro-enabled workbook
 

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 -

can't find macros in a macro-enabled workbook
 

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 -