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.

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

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

"Dave F" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>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.
>

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

On Aug 20, 10:46 am, "Bob Umlas" <Excel_Tricks...@msn.com> wrote:
> see if there's a defined name called auto_open or auto_close
>
> "Dave F" <friedd...@gmail.com> wrote in message
>
> news:(E-Mail Removed)...
>
>
>
> >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 -

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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I don't see defined names auto_open or auto_close....
>
> On Aug 20, 10:46 am, "Bob Umlas" <Excel_Tricks...@msn.com> wrote:
>> see if there's a defined name called auto_open or auto_close
>>
>> "Dave F" <friedd...@gmail.com> wrote in message
>>
>> news:(E-Mail Removed)...
>>
>>
>>
>> >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 -
>
>

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" <KingOfWhi...@aol.com> 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" <friedd...@gmail.com> wrote in message
>
> news:(E-Mail Removed)...
>
>
>
> >I don't see defined names auto_open or auto_close....
>
> > On Aug 20, 10:46 am, "Bob Umlas" <Excel_Tricks...@msn.com> wrote:
> >> see if there's a defined name called auto_open or auto_close
>
> >> "Dave F" <friedd...@gmail.com> wrote in message
>
> >>news:(E-Mail Removed)...
>
> >> >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 -

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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>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" <KingOfWhi...@aol.com> 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" <friedd...@gmail.com> wrote in message
>>
>> news:(E-Mail Removed)...
>>
>>
>>
>> >I don't see defined names auto_open or auto_close....
>>
>> > On Aug 20, 10:46 am, "Bob Umlas" <Excel_Tricks...@msn.com> wrote:
>> >> see if there's a defined name called auto_open or auto_close
>>
>> >> "Dave F" <friedd...@gmail.com> wrote in message
>>
>> >>news:(E-Mail Removed)...
>>
>> >> >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 -
>
>