How to remove warnings about rewriting cells?
 

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

How to remove warnings about rewriting cells?
 

Hi,

Application.displayalerts=false

'do your stuff

Application.displayalerts=true

Mike

"Alexander Aliev" wrote:

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