How to remove warnings about rewriting cells?

A

Alexander Aliev

How to remove warnings about rewriting cells?

Hallo,

I need to remove these questions which appear during
"Selection.TextToColumns" and "Selection.Cut Destination:=<where>" .
Because I know the answer and it always "yes".

I supposed that "Application.EnableEvents = False" before all actions
should resolve the problem but this applied only to "Selection.Cut".

Is there a way to overcome this?
Thank you for any hint.
Alexander
 
M

Mike H

Hi,

Application.displayalerts=false

'do your stuff

Application.displayalerts=true

Mike
 
Top