Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Turn display alerts off then back on at close
'to turn off
application.displayalerts = false 'to turn on application.displayalerts = true The only problem is you cannot run macros until the user has turned them on. Chicken before the egg kind of problem. What I usually do instead is on the workbook_beforeclose event I'll activate an instruction sheet then save the file. This will show the instructions on the next open of the file and the user can then follow to turn on macros. "J.W. Aldridge" wrote: - 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Close workbook without alerts | Excel Programming | |||
Display Alerts | Excel Discussion (Misc queries) | |||
Display Alerts | Excel Programming | |||
Display alerts | Excel Programming | |||
Display Alerts | Excel Programming |