Excel 2007 : Coding for Printing Macro?

Can you please give me the coding for a macro to print current worksheet?

I am creating a workbook for someone else. I dont have a printer so i dont know how to record the macro for printing.
please? thanks in advance

Originally Posted by royUK

Please Login or Register  to view this content.

I entered it. When i clicked on the button it says "Cannot run macro. The macro may not be available in this workbook or all macros is disabled."

??