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

try this TOGGLE sub

Application.DisplayFullScreen = Not Application.DisplayFullScreen = True
===
"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

Jeff,

To add to Don's suggestion, if you put it in workbook event code you can
control as you wish.

That is

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.DisplayFullScreen = False
End Sub

Private Sub Workbook_Open()
Application.DisplayFullScreen = True
End Sub

This display will then only apply to that particular workbook.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Don Guillett" wrote in message
...
try this TOGGLE sub

Application.DisplayFullScreen = Not Application.DisplayFullScreen = True
===
"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

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