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
.