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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to remove warnings about rewriting cells? 1
excel instance stays open 3
here is my code...it's running a bit slow though..any ideas to make it more efficient? thanks 2
Still getting warnings about Comet systems 5
How to check a cell for content before running macro. 1
apply cell change event to single column - WorksheetChange Event 5
go to next cell and paste question 2
Protection to add a line to Remove "Select Locked Cells" ??? 1

Top