Where's the Macro

  • Thread starter Thread starter Ken
  • Start date Start date
K

Ken

I received a workbook from a colleague that asks me to
enable macros when I open it. I say okay and the workbook
opens, but I can't find the macro(s).

I look in Tools.Macro.Macros.. but don't find any macros.

Where are they?

TIA.
 
-----Original Message-----
I received a workbook from a colleague that asks me to
enable macros when I open it. I say okay and the workbook
opens, but I can't find the macro(s).

I look in Tools.Macro.Macros.. but don't find any macros.
Click to expand...

Ken

They may be private macros, or macros written for a
particular sheet in either case you will not see them in
the macro box.

Right-Click on each sheets tab and select View Code to see
if it is there. If not then:
Open the VB editor, ALT + F11 and look for modules or
sheet code.

Regards
Peter
 
Peter, thanks for the tips. I looked there, but saw no
code.

However, I did notice that this workbook had a [shared]
commment attached to it. I removed the sharing, but still
could not see any code.

Not crucial that I figure it out, I'm just one of those
type A's that can't stand to have a puzzlement!
 
It will be VB code, but not a Macro that shows on the Tools Toolbar, maybe a
Workbook_Open event for instance. Hit Alt and F11 to open the VB editor and
you should see the code.
Regards,
Alan
 
Open the VB editor (Alt and F11), see if there are any Modules showing on
the left, if there are, open them to see what's in them, if they are empty,
delete them. An empty module will give you the 'Enable Macros' prompt even
though there is no code,
Regards,
Ken said:
Peter, thanks for the tips. I looked there, but saw no
code.

However, I did notice that this workbook had a [shared]
commment attached to it. I removed the sharing, but still
could not see any code.

Not crucial that I figure it out, I'm just one of those
type A's that can't stand to have a puzzlement!
-----Original Message-----


Ken

They may be private macros, or macros written for a
particular sheet in either case you will not see them in
the macro box.

Right-Click on each sheets tab and select View Code to see
if it is there. If not then:
Open the VB editor, ALT + F11 and look for modules or
sheet code.

Regards
Peter
.
Click to expand...
Click to expand...
 
That was the answer. There was an empty module!
If you are still listening, thanks.
-----Original Message-----
Open the VB editor (Alt and F11), see if there are any Modules showing on
the left, if there are, open them to see what's in them, if they are empty,
delete them. An empty module will give you the 'Enable Macros' prompt even
though there is no code,
Regards,
Peter, thanks for the tips. I looked there, but saw no
code.

However, I did notice that this workbook had a [shared]
commment attached to it. I removed the sharing, but still
could not see any code.

Not crucial that I figure it out, I'm just one of those
type A's that can't stand to have a puzzlement!
-----Original Message-----

-----Original Message-----
I received a workbook from a colleague that asks me to
enable macros when I open it. I say okay and the workbook
opens, but I can't find the macro(s).

I look in Tools.Macro.Macros.. but don't find any macros.

Ken

They may be private macros, or macros written for a
particular sheet in either case you will not see them in
the macro box.

Right-Click on each sheets tab and select View Code to see
if it is there. If not then:
Open the VB editor, ALT + F11 and look for modules or
sheet code.

Regards
Peter
.
Click to expand...
Click to expand...


.
Click to expand...
 
Back
Top