| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
BeforeSave, Cancel and ReadOnly
That does work but it affects all other workbooks open in Excel too, where I
may want to see the alerts. dq wrote: I think the simplest solution would be to put the line Application.Displayalerts = False in the WorkBook_Open event to surpress the errormessage as the saving doesn't seem to be a problem |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Workbook_BeforeClose(Cancel As Boolean) - Cancel won't work | Setting up and Configuration of Excel | |||
| Input box to cancel sub when Cancel is clicked. | Excel Programming | |||
| Disabling 'Cancel' option when saving work (Yes/No/Cancel) | Excel Programming | |||
| How to use Excel VBA to cancel Excel readonly status | Excel Programming | |||
| Cancel Macro is user selects 'cancel' at save menu | Excel Programming | |||
Hybrid Mode
