Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
print button
I have a spresdsheet of 5 pages. I only want to print certain highlighted columns,(always the same ones). can i put a button with a macro to print them off when i want them without highkighting them all every time???? -- Caveman ------------------------------------------------------------------------ Caveman's Profile: http://www.excelforum.com/member.php...o&userid=27546 View this thread: http://www.excelforum.com/showthread...hreadid=486167 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
print button
Good morning caveman You can do this yourself, and learn about macros to boot. Tools Macros Record new macro Then hide the columns, print the reoprt and then unhide the columns. When you have done click on the stop button. Then right click over the menu bar and select the Forms toolbar. Using the button tool draw a button and then assign a macro to it (it will probably be called macro1). Voila! A macro that can be called whenever you please! HTH DominicB -- dominicb ------------------------------------------------------------------------ dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932 View this thread: http://www.excelforum.com/showthread...hreadid=486167 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
print button
On the menu bar, View, Custom Views...
This is an approach.. HTH "Caveman" wrote in message ... I have a spresdsheet of 5 pages. I only want to print certain highlighted columns,(always the same ones). can i put a button with a macro to print them off when i want them without highkighting them all every time???? -- Caveman ------------------------------------------------------------------------ Caveman's Profile: http://www.excelforum.com/member.php...o&userid=27546 View this thread: http://www.excelforum.com/showthread...hreadid=486167 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to add a print tab or button in a cell | Excel Discussion (Misc queries) | |||
In excel: when in print preview, 1 button to 'maximise margins' | Excel Worksheet Functions | |||
How do I create a print button? | Excel Worksheet Functions | |||
command button in excel will move when print. | Excel Discussion (Misc queries) | |||
How do I setup a print command button in excel 2003 | New Users to Excel |