When I save a file I consistently get a message about saving a co.
When I save an Excel file on my new XP machine, I am always prompted to
answer a question saying my file may have been overwritten by another user, do I want to save a copy or overwrite changes. I want to automatically overwite - even though nobody else is accessing the file.... Can I disable this warning? |
In Workbook_BeforeSave() write:
Application.DisplayAlerts = False and in Workbook_BeforeClose() write: Application.DisplayAlerts = True Swisse |
cyn
Have a look at this KB Article "The file may have been changed..." error when you save work*book to network server in Excel 2002 http://support.microsoft.com/default.aspx?kbid=324491 Myrna Larson also reported that she got this error when open*ing a workspace (*.xlw) file. Opening the workbooks individually solved the problem. Gord Dibben Excel MVP On Tue, 1 Feb 2005 11:51:03 -0800, "cynspin" wrote: When I save an Excel file on my new XP machine, I am always prompted to answer a question saying my file may have been overwritten by another user, do I want to save a copy or overwrite changes. I want to automatically overwite - even though nobody else is accessing the file.... Can I disable this warning? |
All times are GMT +1. The time now is 05:37 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com