Skip confirming message

RaymondR32 · Mar 20th, 2002, 02:29 AM

Dear all,

I have created a macro. In some part there is a pop up which says do you want to overwrite the not empty cells ? I always confirm with yes but it interupts the macro which is very anoying. Can excel skip the message and automatic overwrite the not empty cells ?

Thanks in advance.

Raymond

Derek · Mar 20th, 2002, 02:35 AM

Hi Raymond

Try this at the start of your macro

Application.AlertBeforeOverwriting = False

regards
Derek

Tom Schreiner · Mar 20th, 2002, 02:37 AM

Hi,

Put this code at the beginning of your macro

Application.DisplayAlerts = False

Put this code at the end of your macro

Application.DisplayAlerts = True

RaymondR32 · Mar 20th, 2002, 03:06 AM

Thanks guys, it worked ! You´ve been a great help...

Raymond

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

Mar 20th, 2002, 02:29 AM	#1
RaymondR32 New Member Join Date: Feb 2002 Posts: 12	Dear all, I have created a macro. In some part there is a pop up which says do you want to overwrite the not empty cells ? I always confirm with yes but it interupts the macro which is very anoying. Can excel skip the message and automatic overwrite the not empty cells ? Thanks in advance. Raymond

Mar 20th, 2002, 02:35 AM	#2
Derek Board Regular Join Date: Feb 2002 Location: Perth Australia Posts: 1,567	Hi Raymond Try this at the start of your macro Application.AlertBeforeOverwriting = False regards Derek

Mar 20th, 2002, 02:37 AM	#3
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	Hi, Put this code at the beginning of your macro Application.DisplayAlerts = False Put this code at the end of your macro Application.DisplayAlerts = True

Mar 20th, 2002, 03:06 AM	#4
RaymondR32 New Member Join Date: Feb 2002 Posts: 12	Thanks guys, it worked ! You´ve been a great help... Raymond