I have assigned a macro to a radio (print) button that will print a specific range (report) and insert a timestamp in a dedicated cell to indicate the date/ time when that report was printed (using the =NOW() function)
There are multiple buttons with the assigned macros and cell ranges updated respectively but, regardless of which button I press, all other timestamps update to reflect the time the most recent button was actioned.
If someone could review the code below and make a suggestion it would be appreciated
Sheets("Oil Record Book Sheets").Select
Selection.PrintOut Copies:=1, Collate:=True
ActiveCell.FormulaR1C1 = "=NOW()"