Stumped - Problem with Macro Security settings?
This one really has me stumped, so I'm hoping someone has an idea what might
be causing this. I'm using Excel 2007 SP2 in a Windows XP SP3 environment.
The workbook was created in 2007 and never existed in an older format.
I have a workbook with a ton of code in it. Everything works exactly as
it's supposed to. The problem only occurs when I change the macro security
settings.
If I leave the security level at "Disable all macros with notification" and
then manually enable content each time the workbook is opened, then no
problem. But, if I change the settings to "Enable all macros" or set up the
save folder as a Trusted Location, then 2 problems suddenly start to happen.
The results are the same on 4 different computers.
First, this block of code immediately posts an error:
Private Sub Worksheet_Calculate()
If Range("M8").Value = "BALANCED" And
Worksheets("Data").Range("T2").Value < "" Then
SubmitReport.Enabled = True
Else
SubmitReport.Enabled = False
End If
End Sub
Second, whenever I try to save or close Excel, the application crashes and
all changes are lost.
So, basically, if I manually enable macros, its fine. If I automatically
enable macros, it doesn't work.
I suppose we can live with manually enabling macros each time, but I'm still
really curious what is causing this problem.
Any ideas??
Thanks!
Elkar
|