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

--
augie
-----------------------------------------------------------------------
augiem's Profile: http://www.excelforum.com/member.php...fo&userid=3518
View this thread: http://www.excelforum.com/showthread.php?threadid=54951

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


augiem wrote:

> 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
> 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't
> appear to be that. Also, have saved it several times using other methods
> but it always carries this "problem" with it. Any help would be
> appetiated.
>
>
> --
> augiem
> ------------------------------------------------------------------------
> augiem's Profile: http://www.excelforum.com/member.php...o&userid=35187
> View this thread: http://www.excelforum.com/showthread...hreadid=549515

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,

"augiem" <(E-Mail Removed)> wrote in
message news:(E-Mail Removed)...
>
> 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
> 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't
> appear to be that. Also, have saved it several times using other methods
> but it always carries this "problem" with it. Any help would be
> appetiated.
>
>
> --
> augiem
> ------------------------------------------------------------------------
> augiem's Profile:
> http://www.excelforum.com/member.php...o&userid=35187
> View this thread: http://www.excelforum.com/showthread...hreadid=549515
>