View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default save file notification

Hi Dan:

Include this macro in the workbook coding area:

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

--
Gary''s Student - gsnu200738


"Dan" wrote:

How to skip the: "Do you you want to save changes you nade to....."
notification??
(files which are read only for all usesr)
thanks