View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
job job is offline
external usenet poster
 
Posts: 65
Default Ok possible work around

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