Ignore Prompt during macro run?

loves_automation · Feb 22nd, 2002, 12:36 PM

I have a selection.merge command in my macro on a set of cells with the same value. This causes Excel to prompt me "Keep only value in top cell?" to which I have to click "Yes". This totally defeats the purpose of my macro, which is to eliminate user intervention. There must be something I can add to my macro to merge without prompting the user?

RWinfield · Feb 22nd, 2002, 12:39 PM

Add the following prior to the selection merge:

Application.DisplayAlerts=False

and before the end of the macro turn it back on:

Application.DisplayAlerts=True

Rick

loves_automation · Feb 22nd, 2002, 12:45 PM

works like a charm!!! thanks!!!

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

Feb 22nd, 2002, 12:36 PM	#1
loves_automation New Member Join Date: Feb 2002 Posts: 7	I have a selection.merge command in my macro on a set of cells with the same value. This causes Excel to prompt me "Keep only value in top cell?" to which I have to click "Yes". This totally defeats the purpose of my macro, which is to eliminate user intervention. There must be something I can add to my macro to merge without prompting the user?

Feb 22nd, 2002, 12:39 PM	#2
RWinfield New Member Join Date: Feb 2002 Location: Washington State Posts: 33	Add the following prior to the selection merge: Application.DisplayAlerts=False and before the end of the macro turn it back on: Application.DisplayAlerts=True Rick

Feb 22nd, 2002, 12:45 PM	#3
loves_automation New Member Join Date: Feb 2002 Posts: 7	works like a charm!!! thanks!!!