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

Thanks!
 

Thanks, Ron - works fine.
-----Original Message-----
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 news:00bf01c3a3c5$d555ca40
...
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



.