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
|