How to enable macro when Excel doesn't give you an option
 

I have a spreadsheet from a co-worker with macros and vb
code. When I open it, Excel doesn't give me an option to
enable macros. How can I view the macros and vb code?

Thanks for any suggestions,

WayneM

How to enable macro when Excel doesn't give you an option
 

Wayne,

What version of Excel are you using??

Try Tools/Macro/Security and set it to Medium

John

WayneM wrote:

I have a spreadsheet from a co-worker with macros and vb
code. When I open it, Excel doesn't give me an option to
enable macros. How can I view the macros and vb code?

Thanks for any suggestions,

WayneM

How to enable macro when Excel doesn't give you an option
 

John,

Thanks. Your suggestions works. I am using Excel 2k.

WayneM
-----Original Message-----
Wayne,

What version of Excel are you using??

Try Tools/Macro/Security and set it to Medium

John

WayneM wrote:

I have a spreadsheet from a co-worker with macros and vb
code. When I open it, Excel doesn't give me an option
to
enable macros. How can I view the macros and vb code?

Thanks for any suggestions,

WayneM

.