ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Eliminating Prompts (https://www.excelbanter.com/excel-programming/271250-eliminating-prompts.html)

Andrew Park

Eliminating Prompts
 
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.


All times are GMT +1. The time now is 07:17 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com