I have a workbook which contains macros assigned to buttons, hyperlinks, cells to enter data and a =today() variable.

I need a macro like a private sub to stop me from being prompted every time I open the workbook to save it when no changes are made.

I want to be prompted to save the worbook when any data is entered or a macro assigned to a button is run with coding. If the document is formatted in anyway where a picture is inserted or a cell is formatted, then I'd still like to be prompted. Only really though when any changes are made.

I don't want to be prompted to save the workbook when I simply view the workbook, click on a different cell, navigate from sheet to sheet or click a hyperlink

I know the =today() variable may be a problem but even removing this does not remove the problem.

Any ideas?

Thanks.