Thread: Resetting Screen to Full
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default Resetting Screen to Full
You can use a Auto_Close() macro

with this line

Application.DisplayFullScreen = False


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Phil Hageman" wrote in message ...
I have an Auto_Open() sub that sets screen size to full
with the following:

Application.DisplayFullScreen = True

When the user exits the workbook, how do I reset full
screen to False?

Thanks,
Phil



Reply With QuoteReply With Quote