View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett[_4_] Don Guillett[_4_] is offline
external usenet poster
 
Posts: 2,337
Default Turn off Excel Visual Displays

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