Need macro to show that workbook has been saved

I have a workbook that I constantly am improving with new macros and VB routines. I sometimes have two versions available for use at the same time. I would like to create a macro or routine that will tell me if the workbook has been saved. A simple cell color change to indicate I've saved would be fine. Also, if I DO save the file and the cell color changes to indicate I have saved, I would like the cell color to change back if any change is made to the workbook. This way I will always know if I need to save or not to keep latest changes. Any suggestions?

Thanks for the reply. The problem is that I don't know what the code is or where to put the code. I have a pretty basic understanding of macros and VB, but I get confused as to what goes where.

Why do you need this? If you attempt to close an unsaved workbook, Excel will prompt you to save. In addition, if you use a macro in the sheet_change of workbook_sheetchange event that changes any sheet in any way, it will clobber your Undo stack.

You could use the status bar; code goes in ThisWorkbook.

Please Login or Register  to view this content.