View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
J.W. Aldridge J.W. Aldridge is offline
external usenet poster
 
Posts: 425
Default Turn display alerts off then back on at close

- on open, i need to turn all automated display alerts off.
- then give my own alert (informing whomever opens the workbook how to
change security level in order to run macros)
- on close, cancel the alert 'do you want to save changes' message,
- but turn display alerts back on.