Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I select / deselect columns for printing
I have an excel spreadsheet with a large number of columns for viewing on
screen. Its not practical to print this spreadsheet because of its width. The users insist on printing, but each user wants to see different columns. I would like to find a way to put a check box in Row 1 of each column, giving the user the ability to select which columns to print. I would also like to set a default setting so that the typical user could print without taking time to make his selections. Any ideas for code that will solve this problem. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I select / deselect columns for printing
This sounds like a perfect use for Custom Views.
Check out VIEW / CUSTOM VIEWS HTH, -- Gary Brown "TomH" wrote: I have an excel spreadsheet with a large number of columns for viewing on screen. Its not practical to print this spreadsheet because of its width. The users insist on printing, but each user wants to see different columns. I would like to find a way to put a check box in Row 1 of each column, giving the user the ability to select which columns to print. I would also like to set a default setting so that the typical user could print without taking time to make his selections. Any ideas for code that will solve this problem. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deselect B1 & move curser to select A1 | Excel Discussion (Misc queries) | |||
select all, deselect these | Excel Discussion (Misc queries) | |||
How to select and deselect rows in Excel | Excel Discussion (Misc queries) | |||
How to select and deselect rows in Excel | Excel Discussion (Misc queries) | |||
Select all/Deselect all button in a form | Excel Programming |