Hi, Nick,

I don't know if this would work, but you could try it - run the macro to
save the active workbook, instead of Ctrl-S/Save Button

Sub SaveMe()
Application.displayalerts = false
Activeworkbook.save
Application.displayalerts = true
End Sub

The first line will turn off all screen prompts (including hopefully yours),
the third will turn them back on again.

Hope this works

Pete



"Nicko" wrote:


Hello Guys,

I have created a (password to open) workbook using Excel 2003 SP1 on a
shared network drive which when I try to save by using Ctrl S or
clicking the Save icon gives me an irritating dialog box which asks:

"The file 'filename.xls' may have been changed by another user since
you last saved it. In that case what do you want to do?"

-Save a copy
-Overwrite changes


Please can someone tell me how to deactivate this annoying dialog box
as I have been unsuccesful so far in my efforts

Many thanks in advance

Nick


--
Nicko
------------------------------------------------------------------------
Nicko's Profile: http://www.excelforum.com/member.php...o&userid=29477
View this thread: http://www.excelforum.com/showthread...hreadid=491778