| 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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to close Read Only file without prompt to save copy
Try
Private Sub Workbook_BeforeClose(Cancel As Boolean) Me.Close False End Sub -- Jacob (MVP - Excel) "David" wrote: 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to close Read Only file without prompt to save copy
Thanks Jacob (I made sure to click on yes)
Worked fine Is there any way to close the application "shell" along with the file as is usual with only a single file open? "Jacob Skaria" wrote: Try Private Sub Workbook_BeforeClose(Cancel As Boolean) Me.Close False End Sub -- Jacob (MVP - Excel) "David" wrote: 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to close Read Only file without prompt to save copy
Ofcourse YES; Try the below. Be careful this will quit the app; even if you
have other workbooks open.. Private Sub Workbook_BeforeClose(Cancel As Boolean) Application.DisplayAlerts = False Application.Quit End Sub -- Jacob (MVP - Excel) "David" wrote: Thanks Jacob (I made sure to click on yes) Worked fine Is there any way to close the application "shell" along with the file as is usual with only a single file open? "Jacob Skaria" wrote: Try Private Sub Workbook_BeforeClose(Cancel As Boolean) Me.Close False End Sub -- Jacob (MVP - Excel) "David" wrote: 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 |
| Reply |
| 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) | |||
Linear Mode
