Application.DisplayAlerts(resolved)

James · May 18th, 2002, 03:11 PM

In my code the file closes without being saved which is what i want it to do.How can i
suppress Excels save message? I've tried Application.DisplayAlerts with no success.
Any ideas would be appreciated.

James

_________________

[ This Message was edited by: James on 2002-05-18 15:28 ]

Ricky Morris · May 18th, 2002, 03:37 PM

Try:

Application.DisplayAlerts = False

or

ActiveWindow.Close savechanges:=False

James · May 18th, 2002, 04:26 PM

Hi Ricky,

Thanks for the reply, i was trying the DisplayAlerts. It ends up that another part of the code was firing off in front of it.

Regards,
Jim

May 18th, 2002, 03:37 PM	#2
Ricky Morris Board Regular Join Date: Mar 2002 Posts: 363	Try: Application.DisplayAlerts = False or ActiveWindow.Close savechanges:=False __________________ It's never too late to learn something new. Ricky

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 18th, 2002, 03:11 PM	#1
James Board Regular Join Date: Feb 2002 Location: Huntington Beach, CA USA Posts: 327	In my code the file closes without being saved which is what i want it to do.How can i suppress Excels save message? I've tried Application.DisplayAlerts with no success. Any ideas would be appreciated. James _________________ [ This Message was edited by: James on 2002-05-18 15:28 ]

May 18th, 2002, 04:26 PM	#3
James Board Regular Join Date: Feb 2002 Location: Huntington Beach, CA USA Posts: 327	Hi Ricky, Thanks for the reply, i was trying the DisplayAlerts. It ends up that another part of the code was firing off in front of it. Regards, Jim