| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable Save As dialog on ReadOnly spreadsheet
Hi All,
How can I disable the Save As prompt from appearing in a Read Only spreadsheet? something along the lines of (pseudo code) if workbook.readonly then close the workbook without saving else save the changes end What event should any code be put in ? Andy |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Disable Save As dialog on ReadOnly spreadsheet
it definitely should be in auto_close. also the beforesave event in the workbook
event. hope this helps kanan "Andy" wrote: Hi All, How can I disable the Save As prompt from appearing in a Read Only spreadsheet? something along the lines of (pseudo code) if workbook.readonly then close the workbook without saving else save the changes end What event should any code be put in ? Andy |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Force a Readonly Workbook to save to a different folder | Excel Discussion (Misc queries) | |||
| How do you disable save file dialog? | Setting up and Configuration of Excel | |||
| Disable update links dialog box | Excel Programming | |||
| enable/disable macro's dialog? | Excel Programming | |||
| Disable Clipboard Dialog Box during Macro | Excel Programming | |||
Linear Mode
