View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
TomH TomH is offline
external usenet poster
 
Posts: 13
Default 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.