Notification when macro is executed

[Riaaz66]

Hi,

I have a workbook containing different sheets. One sheet is a main sheet with several buttons that are attached to VBA codes.

What I want is that when I press a "macro'-button, the cell next to the button should have the value "Done."

How can I get this done.

Regards,

Riaaz

[tinyjack]

At the end of the code, update the cell value.

The bigger question is surely when do you know if it has not been done?

TJ

[Ago]

'change cell below
Range("A1").value = "Done."




like that?

[Cyberdude]

The next question is: when do you reset all the "Done's"?
I usually choose to post the execution date (and time if appropriate) instead of "Done".
You can reset all the "Done's" to blank whenever you open the workbook, if that makes sense in your application. I do that a lot. Or you can reset the "Done's" when you close the workbook. Whatever.

[Simon Lloyd]

Why not change the text on the button to "Has been Run" or "Run " and the date?