How do I link a button created with VBA with a procedure in another module?

[Glory]

Code creates button. How do I link the button with some code?

ThisWorkbook.ActiveSheet.OLEObjects.Add ClassType:="Forms.CommandButton.1", _
                                        Height:=32, _
                                        Object:="Update", _
                                        Left:=292, _
                                        Top:=34, _
                                        Width:=102

 

[Jaafar Tribak]

HERE is the code which hides the Now Printing window without causing the screen to freeze.

I couldn't come up with a solution for putting the code inside the Workbook_BeforePrint event which would have been much more efficient due to the difficulty to cater for the various ways of raising the print event (Print, PrintPrevieu etc) .

 

[Glory]

That will be way, way more efficient a solution than the only other one I've run across, judging from my quick test run.

Anytime I see somebody ask the question, I'll know exactly where to point them.