Many thanks for your reply Peter,

I'm afraid I am still at a very basic stage with VB. I was hoping that
one of you experts would know how to switch it off in the programme -
if it's not to complicated to explain how/where would I save this
script?

many thanks
Nick

Peter Rooney Wrote:
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




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