I'm looking to do something like
If Application.DesignMode = True Then
Application.DesignMode = False
Else
End If
The Idea is to stop users from putting the program into Design Mode and disableing macros.
The above will not work as it is written. What struck me as curious is that when I typed application.designmode
EXCEL changed it to Application.DesignMode as if EXCEL reccognized this a a key word.
Whats up with that?
Yours in EXCELent Frustration
KniteMare
_________________
Of course I can, and it will take only 900 hours of programming time to do it.
This message was edited by KniteMare on 2002-08-27 04:36
If Application.DesignMode = True Then
Application.DesignMode = False
Else
End If
The Idea is to stop users from putting the program into Design Mode and disableing macros.
The above will not work as it is written. What struck me as curious is that when I typed application.designmode
EXCEL changed it to Application.DesignMode as if EXCEL reccognized this a a key word.
Whats up with that?
Yours in EXCELent Frustration
KniteMare
_________________
Of course I can, and it will take only 900 hours of programming time to do it.
This message was edited by KniteMare on 2002-08-27 04:36