Print command box

M

Meghan

Hello, I am working in an Excel spreadsheet and would like to add a command
box that prints onto the worksheet. How do I go about doing this and what is
the code. I only know that i use Visual Basics I think.
 
D

Dave Peterson

Record a macro (Tools|macro|record new macro)
when you print the worksheet.
Then stop the recording of the macro.

Now show the Forms toolbar (View|toolbars)
Click on that button icon
draw it onto the worksheet (you can move it later).

Then assign that recorded macro to that button.

(If you need to, you can rightclick on that button and assign the macro when you
want to--you don't have to do it when you plop the button onto the worksheet.)
 
Top