Exclude worksheets for pdf-file generation

[eoe]

Dear all, <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

I have a workbook containing presentation and “background” data sheets (needed for charts).How can I exclude these data sheets if I save the workbook in pdf format?

Erik

[Amjad_Sahi]

Hi,

Well, you may hide your unwanted sheets before saving the workbook to pdf format.

e.g

workbook.Worksheets[“DataSheet1”].IsVisible = false;


Thank you.