ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Enable Warnings (https://www.excelbanter.com/excel-programming/322432-enable-warnings.html)

Scott

Enable Warnings
 
I've got a lot of code running in my workbook and have noticed that when I
exit files after making changes, excel doesn't promt to save.

What's the syntax to enable warnings?



Tim Williams

Enable Warnings
 
Warnings should be enabled by default - perhaps you're turning them off in
your code?

anyway:

application.displayalerts=true

should work.

Tim

"scott" wrote in message
...
I've got a lot of code running in my workbook and have noticed that when I
exit files after making changes, excel doesn't promt to save.

What's the syntax to enable warnings?





Bob Phillips[_6_]

Enable Warnings
 
Application.DisplayAlerts = True

--

HTH

RP
(remove nothere from the email address if mailing direct)


"scott" wrote in message
...
I've got a lot of code running in my workbook and have noticed that when I
exit files after making changes, excel doesn't promt to save.

What's the syntax to enable warnings?






All times are GMT +1. The time now is 11:04 PM.

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