| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to close Read Only file without prompt to save copy
Hi
I'm working on an Excel file that will always be opened as Read Only by users. To save confusion I would rather the user is not prompted to save the file on exit. I've tried application.displayAlerts = False in the Workbook BeroreClose event code but no joy so far. Is it posible to achieve this? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to save and close, then copy file | Excel Discussion (Misc queries) | |||
| Save copy of file to open as read only | Excel Discussion (Misc queries) | |||
| Intercepting the file save prompt before close? | Excel Programming | |||
| CLOSE ALL macro for XL2K (but with prompt to save for each file)? | Excel Programming | |||
| Save Changes Prompt at close | Excel Discussion (Misc queries) | |||
Threaded Mode
