B
bsullins
Greetings,
I am attempting to either
Change macro security level to low so my user does not get the 'enabl
macros' dialogue box
OR
Test to see if macro's are enabled...
If the macro's are disabled then show a warning asking the user t
enable them.
Here's what i've been able to come up with but its not working ver
well, anything will help..
/***************************************/
Sub Security()
If Application.AutomationSecurity
msoAutomationSecurityForceDisable Then
MsgBox "You must enable macro's to use this workbook"
End If
End Sub
/***************************************
I am attempting to either
Change macro security level to low so my user does not get the 'enabl
macros' dialogue box
OR
Test to see if macro's are enabled...
If the macro's are disabled then show a warning asking the user t
enable them.
Here's what i've been able to come up with but its not working ver
well, anything will help..
/***************************************/
Sub Security()
If Application.AutomationSecurity
msoAutomationSecurityForceDisable Then
MsgBox "You must enable macro's to use this workbook"
End If
End Sub
/***************************************