turn off 'save' prompt when closing Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dawnyanne - 18 Sep 2007 11:20 GMT

hi there
Is there a way to 'turn off' the prompt "Do you want to save your changes?"
when you close excel? Many thanks for any help!

Dawnyanne

Reply to this Message

Mike H - 18 Sep 2007 12:06 GMT

Hi,

Alt+F11 to open VB editor. Double click this workook and paste this in:-

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Me.Saved = True
End Sub

Mike

> hi there
> Is there a way to 'turn off' the prompt "Do you want to save your changes?"
> when you close excel? Many thanks for any help!
>
> Dawnyanne

Reply to this Message

Dawnyanne - 18 Sep 2007 12:26 GMT

Hi Mike

Thank you so much!!

> Hi,
>
[quoted text clipped - 11 lines]
> >
> > Dawnyanne

Reply to this Message