Eliminating Prompts

A

Andrew Park

I've written some macros that copy and paste large amounts
of information, and when I delete a sheet, it gives me a
prompt to save the information on the clipboard.

On one computer, the commands:

Application.DisplayAlerts = False
....
Application.DisplayAlerts = True

work fine. On another one, though, it doesn't. I was
wondering if there's a different way of doing the same
thing, or why this might be happening. Thanks.
 

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

Top