VBA - Activate a macro upon printing

Dear Excel Forum,

I am having an issue with an Excel/VBA-related task at work, something I have not been able to work out despite extensive research. I took some time to look through previous threads here on the forums, but since I have a deadline, I decided to ask away. I can work with graphs and functions, but not with VBA (I am a tech, not a programmer). I hope I have come to the right place for help.

I have managed to write a simple macro which, upon pressing a shortcut, adds 1 to a number in a specific field. I need to make this happen each time I print a copy of the worksheet. That is, if I choose to print 200 copies, they will be numbered 0000 - 0200, with a unique number printed on each copy.

This is the macro I managed to put together:

Sub Numbering()
    Range("G1") = Range("G1") + 1
    
End Sub

Could someone tell me how to make it work as I have described above? I would be really grateful.