macro disabled

  • Thread starter Thread starter Mo. bannayan
  • Start date Start date
M

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.
 
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
 
Back
Top