Why aren't macros enabled?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I open up the file, I don't get asked whether I want to enable or disable macros. The file just appears with macros disabled. I can get them to run manually, but that creates more work and defeats the purpose of having buttons on my form. When I open an older version of this file (I have made mods since), I do get asked whether I want to enable or disable macros. ??

My security is set to medium. I am not the original creator of the file, but I am able to modify & save it
They moved our files to a new server over the weekend and I'm on a different computer, but don't think that should've affected it. Does it matter whether your sheet is protected or not?
 
Lon

It is a simple security matter. You must be sure that you
can trust the macros imagine the trouble this might cause

With ActiveSheet
cells.clear

.....

Regards
Peter
-----Original Message-----
When I open up the file, I don't get asked whether I want
Click to expand...
to enable or disable macros. The file just appears with
macros disabled. I can get them to run manually, but that
creates more work and defeats the purpose of having
buttons on my form. When I open an older version of this
file (I have made mods since), I do get asked whether I
want to enable or disable macros. ???
My security is set to medium. I am not the original
Click to expand...
creator of the file, but I am able to modify & save it.
They moved our files to a new server over the weekend and
Click to expand...
I'm on a different computer, but don't think that
should've affected it. Does it matter whether your sheet
is protected or not?
 
Back
Top