get rid off Excel Error MsgBox???

Muratti · Apr 22nd, 2002, 03:51 PM

Does anybody know how I can get rid off a Excel error message? I just want it to simply click ok, and then continue. Is there a line of code that can do this, do I have to trap this error?
Any recommendation is appreciated.

James · Apr 22nd, 2002, 03:58 PM

Application.DisplayAlerts = False
"your code"
Application.DisplayAlerts = True
End Sub

James

Muratti · Apr 22nd, 2002, 04:27 PM

James, thanks. But it gives an error when I saved the document(trying to share workbooks), so it is not related to my code, it is related to excel. I want to get rid of that message by automatically making it to click on OK. Any idea? Thanks again.

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

Apr 22nd, 2002, 03:51 PM	#1
Muratti New Member Join Date: Apr 2002 Posts: 16	Does anybody know how I can get rid off a Excel error message? I just want it to simply click ok, and then continue. Is there a line of code that can do this, do I have to trap this error? Any recommendation is appreciated.

Apr 22nd, 2002, 03:58 PM	#2
James Board Regular Join Date: Feb 2002 Location: Huntington Beach, CA USA Posts: 327	Application.DisplayAlerts = False "your code" Application.DisplayAlerts = True End Sub James

Apr 22nd, 2002, 04:27 PM	#3
Muratti New Member Join Date: Apr 2002 Posts: 16	James, thanks. But it gives an error when I saved the document(trying to share workbooks), so it is not related to my code, it is related to excel. I want to get rid of that message by automatically making it to click on OK. Any idea? Thanks again.