Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
BeforeSave, Cancel and ReadOnly
Hello
I am using the BeforeSave event to replace the normal save action with one that determines changed data and writes it to a database. The basic structure is as follows: Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) MsgBox "This would be the custom save action" Cancel = True End Sub This works fine except when the workbook is read-only, which I require to prevent users from messing around with the xls file, deleting it accidently or whatever. Then it displays the message: 'savetest.xls' is read-only. To save a copy, click OK, then give the workbook a new name in the Save As dialog box. and continues as it should do with the custom action. How do I get it to stop displaying that message box? It's entirely useless in this case and just confuses people. Thanks Steve |
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 |