Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Print command box
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. -- Thanks Meghan |
#2
|
|||
|
|||
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.) Meghan wrote: 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. -- Thanks Meghan -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
One spreadsheet cell won't print but shows up in print preview? | Excel Discussion (Misc queries) | |||
Print and Print Preview don't match screen | Excel Worksheet Functions | |||
set the print area print multiple tabs | Excel Discussion (Misc queries) | |||
Printing - Have to set print area 1 column further than necessary | Excel Discussion (Misc queries) | |||
Microsoft Excel could not find anything to print | Excel Discussion (Misc queries) |