| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create a column that does not print
If you hide the column it won't print.
You can do this manually by selecting the column and FormatColumnHide. If you want a macro..................... Turn on the macro recorder at ToolsMacroRecord New Macro. Hide the column, do your print, unhide the column. Turn off recorder. Now you have a macro that will do the same thing print after print. If you're not familiar with VBA and macros, see David McRitchie's site for more on "getting started". http://www.mvps.org/dmcritchie/excel/getstarted.htm or Ron de De Bruin's site on where to store macros. http://www.rondebruin.nl/code.htm Gord Dibben MS Excel MVP On Mon, 12 Jan 2009 14:01:01 -0800, Kelly wrote: The column is in the middle and I cant move it, but a macro seems like it would work. Unfortunately I not familar with Macros or how to write them... Do you know of any resources out there that I can go to get something or at least get a little 'educated' |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Print Column Heads WITHOUT Excel Column Lables | Excel Worksheet Functions | |||
| cell borders that I create dont show on print preview or print | Excel Discussion (Misc queries) | |||
| Create a print macro that would automatically select print area? | Excel Worksheet Functions | |||
| How I can print full text bigger than column, in repeat column | Excel Discussion (Misc queries) | |||
| How do I create a print button? | Excel Worksheet Functions | |||
Threaded Mode
