macro disabled

[Mo. bannayan]

Hi there;
well I got a file from a friend which contains a macro, but when I open it a
message pop in as the macro is disabled and I should change the security
level on my PC. I changed the security level from high to low and opened the
file again still I cannot see the macro in visaul basic editor.
Would you please let me know what should I do?
Thanks
Mo.

 

[Andy Brown]

You shouldn't set your level lower than Medium.

Can you see any macro names when you ALT+F8? Can you see any modules in VBE?
There may be code in the worksheet module(s) -- rightclick the worksheet
tab(s) & "View Code". Finally, if code has been removed but the module that
stored it is still there, you'll still get the alert. See
http://www.contextures.com/xlfaqMac.html#NoMacros for more info.

Rgds,
Andy

 

[Mo. bannayan]

Thank you, with Alt+F8 I found the macros.
Best
Mo.