How to supress header on first page in Excel 1

[TimRHSD]

Howdy!

Is it possible to supress headers (e.g. LeftHeader) on the first page of a printout? The client I am doing this for is using Excel 97. Suggestions and comments would be appreciated.

Thanks,

Tim

 

[tyhand]

When you say "LeftHeaders" do you mean the regular Header/Footer or are you referring to the Columns & Rows?

You can choose which of your excel sheets print the Columns & Rows by going to File a nd selecting "Page Setup..." Once there, Click the "Sheet" Tab and select "Row and column headings". You can also choose custom Headers and Footers by clicking the "Header/Footer" tab.

Programatically it'd be:
ActiveSheet.PageSetup.PrintHeadings = True (or False)

Hope this helps. Peace!

 

[TimRHSD]

Thanks Tyhand, Actually what I want is the ability with VBA to suppress the headers (e.g. LeftHeader) on the first page, then print them on the following pages. I don't think it can be done unless a newer version of Excel (I have 2000) allows it.

Tim

Tim Rutherford

http://www.Manna-Consulting.com

 

[VulcanJedi]

Create a different first page header or footer

You can leave the header or footer off the first page or create a unique first page header or footer for the first page in a document or the first page of each section within a document.

If your document is divided into sections, click in a section or select multiple sections you want to change. Click anywhere if your document is not divided into sections.
On the View menu, click Header and Footer.
On the Header and Footer toolbar, click Page Setup .
Click the Layout tab.
Select the Different first page check box, and then click OK.
If necessary, click Show Previous or Show Next on the Header and Footer toolbar to move into the First Page Header area or First Page Footer area.
Create the header or footer for the first page of the document or section.
If you don't want a header or footer on the first page, leave the header and footer areas blank.

To move to the header or footer for the rest of the document or section, click Show Next on the Header and Footer toolbar. Then create the header or footer you want.

Tranpkp

 

[PHV]

tranpkp, you're talking about Word and the topic is Excel.