I'm using code to Application.DisplayFullScreen = True on the open event of
the workbook. In the beforeclose event I have the
Application.DisplayFullScreen = False yet it does not work. Any ideas?

cheers,

Job

Worked fine for me when I tried it with excel 2002. If you are opening the
same workbook, it will open fullscreen because of the code in workbook_open.

HTH

Ken

Ken,

When I open it is just fine, it is on the beforeclose event that it is not
working. If I put two buttons on a sheet, one that displays full screen and
one that sets it back to false it works fine. It simply doesn't work when I
have it associated with the beforeclose workbook event. Is there some
little trick I'm missing?


"Ken Macksey" wrote in message
...
Worked fine for me when I tried it with excel 2002. If you are opening the
same workbook, it will open fullscreen because of the code in
workbook_open.

HTH

Ken

I also failed to mention that I'm closing the sheet with code...not sure if
that would make a difference...
"Ken Macksey" wrote in message
...
Worked fine for me when I tried it with excel 2002. If you are opening the
same workbook, it will open fullscreen because of the code in
workbook_open.

HTH

Ken

If from the menu on the close button I use
me.hide
Application.SendKeys("%fc")
this will now disable the full screen. If I use the code from the button

ActiveWorkbook.Close SaveChanges:=False it doesn't disable...

does anyone know with the send keys how to savechanges:=false?




"Ken Macksey" wrote in message
...
Worked fine for me when I tried it with excel 2002. If you are opening the
same workbook, it will open fullscreen because of the code in
workbook_open.

HTH

Ken