We help IT Professionals succeed at work.

Autoselection of dialog box query

carlosab
carlosab asked
on
My script pastes data from one sheet to another. Both sheets use the same defined name for a range of cells. When the script does the paste, I get this dialog box:

 dialog
I don't want the program to pause for this box and instead want to either never get the box in the first place (preferred) or have the code automatically select "yes"
Comment
Watch Question

have you tried inserting

Application.DisplayAlerts = False

Open in new window



Author

Commented:
Thanks.