Macro to VB
Posted by Anthony on June 19, 2001 7:15 AM
Hello to all! I'm looking to assign buttons to perform commands on my worksheet. I'm referring more towards buttons from the control toolbox and not graphic art or hot-spots. Anyway, I've attempted to do this by creating a marcro then copying that code to the button of my choice. Is that possible? Each time I do this, I receive variuos "run time" error messages. What am I missing? Any advice would be greatly appreciated.
Here's the code, any suggestions?
' Macro3 Macro
' Macro recorded 6/19/2001 by Anthony Badalucco
ActiveWorkbook.PrintOut Copies:=1, Collate:=True