Ah, I see. What I like to do is keep a very hidden sheet in the workbook to track these things, then you can put an indicator in that sheet without sacrificing user interface. It's a bit of a workaround, but it's what I do. Basically, add a new sheet, then run a quick sub for ActiveWorkbook.Sheets("NewSheetName").Visible = xlVeryHidden.
Then as part of the callback for your button clicks, you can set the "A1" value in the hidden sheet to whatever indicator you want. After that, when you go to close the workbook, you can check those values:
That's how I'd go about it. That way, if you add other buttons and the user clicks them, it doesn't mess with anything.
Hope this is satisfactory
Bookmarks