NCC
NCC

Reputation: 819

Turn off copy and copy/move (from workbook to workbook) without promting A formulas or sheet..?

I often get this and have to press enter like 1-5 mins to get rid of it enter image description here

Is there any code to get rid of this?

Upvotes: 1

Views: 176

Answers (1)

Siddharth Rout
Siddharth Rout

Reputation: 149297

Try this.

Application.DisplayAlerts = False

'~~> Your Code

Application.DisplayAlerts = True

Upvotes: 1

Related Questions