View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gary Thomson[_4_] Gary Thomson[_4_] is offline
external usenet poster
 
Posts: 4
Default Printing Each Sheet

Hi,

Is there a Macro I can write which will allow me to print
off each sheet within the workbook, such that each sheet
is:

(i) Centred Horizontally;
(ii) Centred Vertically;
(iii) Fits to 1 page wide by 1 page tall;
(iv) Shows Row and Column headings;
(v) Has the Tab name of the worksheet in the centre of the
header, size 16 point Arial.

Many Thanks.

Gary.