View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John Davies John Davies is offline
external usenet poster
 
Posts: 39
Default set up toggle button to set print area

At times I need to print a different section of a spreadsheet.
Is it possible to set up a toggle button to set the area for printing?
For example to print cells a1:a6 you would click on the button once but to
print cells a1:a20 you would click on it again.

Thanks in advance of a favourable reply.

Regards
John D