Help!

How do you turn off "Save a copy/Overwrite changes" dialog..

 
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Excel General (archive) RSS
Next:  Links not showing updated value  
Author Message
Nicko
External


Since: Dec 08, 2005
Posts: 1



PostPosted: Thu Dec 08, 2005 10:55 am    Post subject: How do you turn off "Save a copy/Overwrite changes" dialog box
Archived from groups: microsoft>public>excel>misc (more info?)

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 :confused:

Many thanks in advance

Nick


--
Nicko
------------------------------------------------------------------------
Nicko's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29477
View this thread: http://www.excelforum.com/showthread.php?threadid=491778
Back to top
Peter Rooney
External


Since: Jan 21, 2005
Posts: 52



PostPosted: Thu Dec 08, 2005 10:55 am    Post subject: RE: How do you turn off "Save a copy/Overwrite changes" dialog box [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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 :confused:
>
> Many thanks in advance
>
> Nick
>
>
> --
> Nicko
> ------------------------------------------------------------------------
> Nicko's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29477
> View this thread: http://www.excelforum.com/showthread.php?threadid=491778
>
>
Back to top
Nicko
External


Since: Dec 08, 2005
Posts: 1



PostPosted: Thu Dec 08, 2005 12:18 pm    Post subject: Re: How do you turn off "Save a copy/Overwrite changes" dialog box [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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 :confused:
> >
> > Many thanks in advance
> >
> > Nick
> >
> >
> > --
> > Nicko
> >
> ------------------------------------------------------------------------
> > Nicko's Profile:
> http://www.excelforum.com/member.php?action=getinfo&userid=29477
> > View this thread:
> http://www.excelforum.com/showthread.php?threadid=491778
> >
> >


--
Nicko
------------------------------------------------------------------------
Nicko's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29477
View this thread: http://www.excelforum.com/showthread.php?threadid=491778
Back to top
Gord Dibben
External


Since: Dec 02, 2005
Posts: 263



PostPosted: Thu Dec 08, 2005 2:22 pm    Post subject: Re: How do you turn off "Save a copy/Overwrite changes" dialog box [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Nicko

Perhaps this will apply.

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 opening a workspace
(*.xlw) file.

Opening the workbooks individually solved the problem.


Gord Dibben Excel MVP

On Thu, 8 Dec 2005 05:55:28 -0600, 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 :confused:
>
>Many thanks in advance
>
>Nick
Back to top
Bob Phillips
External


Since: Jun 08, 2004
Posts: 5103



PostPosted: Thu Dec 08, 2005 6:41 pm    Post subject: Re: How do you turn off "Save a copy/Overwrite changes" dialog box [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Nicko,

Not sure, but try this

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As
Boolean)
Dim sFile
Application.EnableEvents = False
Cancel = True
Application.DisplayAlerts = False
If SaveAsUI Then
sFile = Application.GetOpenFilename("Excel Files (*.xls), *.xls")
If sFile <> False Then
ThisWorkbook.SaveAs sFile
End If
Else
ThisWorkbook.Save
End If
Application.DisplayAlerts = True
Application.EnableEvents = True
End Sub



'This is workbook event code.
'To input this code, right click on the Excel icon on the worksheet
'(or next to the File menu if you maximise your workbooks),
'select View Code from the menu, and paste the code



--

HTH

RP
(remove nothere from the email address if mailing direct)


"Nicko" wrote in
message
>
> 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 :confused:
> > >
> > > Many thanks in advance
> > >
> > > Nick
> > >
> > >
> > > --
> > > Nicko
> > >
> > ------------------------------------------------------------------------
> > > Nicko's Profile:
> > http://www.excelforum.com/member.php?action=getinfo&userid=29477
> > > View this thread:
> > http://www.excelforum.com/showthread.php?threadid=491778
> > >
> > >
>
>
> --
> Nicko
> ------------------------------------------------------------------------
> Nicko's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=29477
> View this thread: http://www.excelforum.com/showthread.php?threadid=491778
>
Back to top
Display posts from previous:   
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Excel General (archive) All times are: Eastern Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum