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