Re: Excel: eliminate warning about saving changes?
Originally Posted by Hack
I think something like this would work
VB Code:
xl.Application.DisplayAlerts = False
It didn't work. Am I doing it right?
VB Code:
Private Sub Workbook_Open()
Application.DisplayAlerts = False
End Sub
I tried to place it in the procedures Workbook_Deactivate and Workbook_BeforeClose as well to no avail.
Lottery is a tax on people who are bad at maths
If only mosquitoes sucked fat instead of blood...
To do is to be (Descartes). To be is to do (Sartre). To be do be do (Sinatra)
Re: Excel: eliminate warning about saving changes?
For now I can make do with this, though it's not too elegant -kind of makes me feel like I'm cheating
VB Code:
Sub Workbook_BeforeClose()
SendKeys vbTab
SendKeys vbCr
End Sub
Lottery is a tax on people who are bad at maths
If only mosquitoes sucked fat instead of blood...
To do is to be (Descartes). To be is to do (Sartre). To be do be do (Sinatra)
Reply With Quote
Originally Posted by Hack
