Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
When an excel file (read only) is loaded and then the user goes to save it.
It then asks the user to save a copy. How do I prevent this from popping up? I thought of Private Sub Workbook_BeforeClose(Cancel As Boolean) Application.DisplayAlerts = False ActiveWorkbook.Close (SaveChanges = False) End Sub But I'm not sure if it always works and if its good to remove display alerts Is this the correct way to do this? Thanks, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Save a copy? | Excel Worksheet Functions | |||
A visual basic value copy BUG?? - accounting format has copy problem!! | Excel Programming | |||
Save column J only using copy/paste & temporary copy | Excel Programming | |||
Save as problem with Save In drop down box | Excel Discussion (Misc queries) | |||
How to save a file without overwrite or save a copy? | Setting up and Configuration of Excel |