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 |
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 |
All times are GMT +1. The time now is 01:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com