Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,302
Default Reset alerts when closing workbook?

Hi Brian,

provided that your macro restores the setting, i.e:

Application.DisplayAlerts = True

after any


Application.DisplayAlerts = False

You should not experience any problem in this regard.

If you still have a problem, post the complete procedure code.

---
Regards,
Norman



"Brian Delaney" wrote in message
...
Thanks for the confirmation, Norman. I thought that should be the case:
that alerts would reappear -- but they still don't. Think this could
possibly have anything to do with my first having tried

Application.DisplayAlerts = True/False

lines?

Brian

*** Sent via Developersdex http://www.developersdex.com ***



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Reset workbook back to Auto Calculate Karl_S Excel Discussion (Misc queries) 8 April 17th 09 09:26 PM
alerts for changes in workbook olga Excel Discussion (Misc queries) 0 October 9th 06 09:07 PM
How reset margins in Excel workbook? KYgirl Excel Discussion (Misc queries) 1 April 29th 05 12:52 AM
closing excel after closing a workbook CWalsh[_2_] Excel Programming 3 January 21st 04 03:33 PM
Closing a workbook with no alerts Antonio Atala Excel Programming 1 September 16th 03 04:32 AM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"