the easiest way to do this is to have the workbook always believe it has been
changed as soon as you open it. In the ThisWorkbook module, put the
following macro...

Private Sub Workbook_Open()
Application.ActiveWorkbook.Saved = False
End Sub

That will make the workbook always believe that it needs to be saved.
--
Hope this helps.
Thanks in advance for your feedback.
Gary Brown


"acss" wrote:

Is there a way to have a password protect on a workbook and once end user
keys in the password, the workbook status will changed to modified?