i would like my line of code not to prompt for a Yes No...

mjschukas · May 24th 2005

???

Code

ActiveWorkbook.Close

???

thank you...

Kieran · May 24th 2005

Re: i would like my line of code not to prompt for a Yes No...

try

ActiveWorkbook.Close SaveChanges:=False

Note you will not save any changes

rbrhodes · May 24th 2005

Re: i would like my line of code not to prompt for a Yes No...

Hi,

Alt+F11 to open the VBE. Click on 'ThisWorkbook' and paste this in. It will always save changes.

Code

Private Sub Workbook_BeforeClose(Cancel As Boolean)
ActiveWorkbook.Save
End Sub

Cheers,

dr

Participate now!