Always asks to save

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

augiem - 07 Jun 2006 16:14 GMT

I have a excel workbook that when opened will then not let you exit th
workbook until saved. This is causing problems because I am using
program called "4 Tops" to import data from that workbook into access
I have looked to see if any macros were causing problems and it doesn'
appear to be that. Also, have saved it several times using other method
but it always carries this "problem" with it. Any help would b
appetiated

Reply to this Message

RichardSchollar - 07 Jun 2006 16:41 GMT

Hi Augiem

Have you checked the ThisWorkbook module for code? Sounds like there
may be something in there firing on the Before_Close event.

Best regards

Richard

> I have a excel workbook that when opened will then not let you exit the
> workbook until saved. This is causing problems because I am using a
[quoted text clipped - 9 lines]
> augiem's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=35187
> View this thread: http://www.excelforum.com/showthread.php?threadid=549515

Reply to this Message

Graham Whitehead - 07 Jun 2006 16:49 GMT

Perhpas this is what you are looking for. It will prevent the nag box
popping up asking you if you want to save the changes when ever you exit the
sheet or excel.

Open the visual basic editor.

On the right you will see a list of sheets assocaited with the current
workbook. Underneath the list of sheets there should be some text
'ThisWorkbook'. double click on this and put this code in.

Private Sub Workbook_BeforeClose(Cancel As Boolean)

ActiveWorkbook.Close savechanges:=False

End Sub

Hope this is what you are looking for,

> I have a excel workbook that when opened will then not let you exit the
> workbook until saved. This is causing problems because I am using a
[quoted text clipped - 3 lines]
> but it always carries this "problem" with it. Any help would be
> appetiated.

Reply to this Message