Turn off Excel Visual Displays

  • Thread starter Thread starter Jeff Marshall
  • Start date Start date
J

Jeff Marshall

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,

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)
 
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.
 
Back
Top