<P ID="edit"><FONT SIZE=-1>Edited by gwhitfield on 15-Jun-01 21:08.</FONT></P>*** edited. Geoff W. Cross-post <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Cat=&Board=xl&Number=45895&page=0& view=expanded&sb=5>here</A> ***

I have to develop some solutions belive it or not in Excel 95. I have encountered the following problems and wonder if there are any solutions.

1. I am trying to close the active book from the cancel button of a dialogue box, but get error 1004 when I use the command Activeworkbook.Close Savechanges:=False
Any Solutions ?

2. I do NOT want my dialog boxes to have a close button top right. Can I remove this ? Do I need to use an API call and if so what ?

3. Is it possible to Cancel the close event of a workbook in Excel 95 and if so how.

NO... I cannot convert to Office 97 or above !

Any help greatfully accepted - Andrew Walker