Hi,
You could do this:-
Private Sub Workbook_Open()
'Make your changes to headers etc
ActiveWorkbook.Saved = True
End Sub
Only changes made after the line
ActiveWorkbook.Saved = True
Should generate a prompt to save changes when closing.
Mike
> I have a workbook where on one sheet the user can use a set of buttons and
> dialogues to add new column headers to a table and then fill in the correct
[quoted text clipped - 9 lines]
> So I wonder if it is possible to tell Excel to ignore changed to certain rows
> when determining if the workbook has been changed.
Erik Wikström - 12 Dec 2007 15:00 GMT
> > I have a workbook where on one sheet the user can use a set of buttons and
> > dialogues to add new column headers to a table and then fill in the correct
[quoted text clipped - 22 lines]
> ActiveWorkbook.Saved = True
> Should generate a prompt to save changes when closing.
Hmm, that might work. Thanks.