Turn off Excel Visual Displays
Application.ScreenUpdating = False
' code that causes the display to change
Application.ScreenUpdating = True
will turn off visual movement on the screen caused by macro activities.
However, if you want to remove elements of the interface such as toolbars
and so forth, you have to do each one explicitly, then restore them.
Generally, if your macro crashes, then your user is hosed.
I don't think most users are confused by the Excel environment.
--
Regards,
Tom Ogilvy
Jeff Marshall wrote in message
...
Hi ,
Is there a command that would turn off all the Excel visual displays ?
(The
tool bar, etc.)
I'm thinking it would be less confusing for the user .
If the macro crashes while the visual displays are off, how would I get
them
on again ?
Thanks Again
Jeff
|