Results 1 to 1 of 1
Thread: Excel 95 Dialog Boxes
2001-06-15, 20:08 #1
- Join Date
- Apr 2001
- Cambridge, UK
- Thanked 3 Times in 3 Posts
Excel 95 Dialog Boxes
<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