Possibly

http://support.microsoft.com/kb/289111/en-us

by the way, there is no problem with UsedRange except possibly in the
initial release of xl2000. Possibly you speak of the a misperception as to
what UsedRange actually portrays.

--
Regards,
Tom Ogilvy


"droopy928gt" wrote:


I've got a very strange problem for which I can't find an explanation.

The application I made quits excel using application.quit. Before
doing this I check if the workbook was saved and if not save it.


Code:
--------------------
'Check if the workbook was saved
If Workbooks(ThisWorkbook.Name).Saved = False Then
'Save this workbook
Workbooks(ThisWorkbook.Name).Save
End If

'Close excel
Application.Quit
--------------------


Using above code I would think that the application would quit without
asking for it to be saved. Well, it doesn't. Only when I add the
application.displayalerts = false statement will it do so. Afterwards
when checking I can't find any differences between a saved and non
saved workbook though. Apart from that, when quiting the application
there's only 1 workbook open.

It becomes weirder when you know that this problem only occurs after
having done something using the application. The application itself is
basically a database which displays data in textboxes depending upon
certain criteria. It has 2 worksheets being 1 for the data used itself
and 1 which contains temp data used in the application. Both sheets
though are saved when using the workbooks().save statement.

Could any of you offer an explanation of this strange behavior or might
have experienced similar before? Is this maybe some sort of bug like
the usedrange problem?

I use the workaround of setting displayalerts to off now but I would
really like to know why this happens.

Thanks and best regards,

Leon


--
droopy928gt
------------------------------------------------------------------------
droopy928gt's Profile: http://www.excelforum.com/member.php...o&userid=30232
View this thread: http://www.excelforum.com/showthread...hreadid=537711