View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
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 ***