Is it possible to diable save change at closing the workbook

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to disable The message you receive at closing and opening, to
save changes and to update file, because I've created a file just for
printing bills where I do not need changes done on the page to be saved, just
like there is no need for updates either.
 
Shariq

You could include a workbook_beforeclose() event code as below. (To
implement right click on the small Excel icon top left of the workbook and
select view code...)

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

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
www.nickhodge.co.uk
 
Back
Top