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

W

WayneM

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
 
J

John Wilson

Wayne,

What version of Excel are you using??

Try Tools/Macro/Security and set it to Medium

John
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with Macro Security 1
VBA word change keys 0
running Excel 2007 macro in Win7 3
including macro in protected worksheet 2
How to enable "enable automatic update" security setting by VB cod 0
Link a text box based on drop down box with four options MS Word 365 0
Converting URLs in comments to Markdown-formatted links 2
security, enabling macros to enable a disabling saving function 12

Top