View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default How do I select multiple worksheets for print preview?

You would have to select the sheets, but then

objExcel.Activewindow.SelectedSheets.PrintPreview( Missing.Value);

I would think.

--
Regards,
Tom Ogilvy

"steve" wrote in message
...
In VBA one can select multiple worksheets by passing an array. How is

this
same thing accomplished using C#?

I would like to select a number of worksheet from the entire workbook for

a
print preview. Thus having only the selected worksheets appear in the
preview.
The following shows the entire workbook.

objExcel.Worksheets.PrintPreview(Missing.Value);

Steve