How do I start Excel Footer on 2nd page?

Thank you Debra. I appreciate your response.

I wonder if it would not be a simple thing for Miscosoft to enable one to do
the same thing in Excel that you can do in Word. I hope they will consider
this possibility.
--
all the easy way of doing things have been taken

dicfor


"Debra Dalgleish" wrote:

> Different first page has always been a feature in Word, but not in Excel.
>
> In Excel, you could print the first page
> Then add the footer, and print the remaining pages.
>
> dicfor wrote:
> > I recently upgraded MS Office. What happened to capability click on
> > "different first page" so I can start footer on 2nd page?
>
>
> --
> Debra Dalgleish
> Excel FAQ, Tips & Book List
> http://www.contextures.com/tiptech.html
>
>

Different first page has always been a feature in Word, but not in Excel.

In Excel, you could print the first page
Then add the footer, and print the remaining pages.

dicfor wrote:
> I recently upgraded MS Office. What happened to capability click on
> "different first page" so I can start footer on 2nd page?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Thank you Debra. I appreciate your response.

I wonder if it would not be a simple thing for Miscosoft to enable one to do
the same thing in Excel that you can do in Word. I hope they will consider
this possibility.
--
all the easy way of doing things have been taken

dicfor


"Debra Dalgleish" wrote:

> Different first page has always been a feature in Word, but not in Excel.
>
> In Excel, you could print the first page
> Then add the footer, and print the remaining pages.
>
> dicfor wrote:
> > I recently upgraded MS Office. What happened to capability click on
> > "different first page" so I can start footer on 2nd page?
>
>
> --
> Debra Dalgleish
> Excel FAQ, Tips & Book List
> http://www.contextures.com/tiptech.html
>
>

Different first page has always been a feature in Word, but not in Excel.

In Excel, you could print the first page
Then add the footer, and print the remaining pages.

dicfor wrote:
> I recently upgraded MS Office. What happened to capability click on
> "different first page" so I can start footer on 2nd page?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Different first page has always been a feature in Word, but not in Excel.

In Excel, you could print the first page
Then add the footer, and print the remaining pages.

dicfor wrote:
> I recently upgraded MS Office. What happened to capability click on
> "different first page" so I can start footer on 2nd page?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Put this in "ThisWorkbook" Event-code module:

Private Sub Workbook_BeforePrint(Cancel As Boolean)
Const sFOOTER As String = "my footer"
Dim wsSheet As Worksheet
Cancel = True
Application.EnableEvents = False
For Each wsSheet In ActiveWindow.SelectedSheets
With wsSheet
.PageSetup.LeftFooter = ""
.PrintOut from:=1, To:=1
.PageSetup.LeftFooter = sFOOTER
.PrintOut from:=2
End With
Next wsSheet
Application.EnableEvents = True
End Sub


"Debra Dalgleish" <[email protected]> wrote in message
news:[email protected]...
> Different first page has always been a feature in Word, but not in Excel.
>
> In Excel, you could print the first page
> Then add the footer, and print the remaining pages.
>
> dicfor wrote:
>> I recently upgraded MS Office. What happened to capability click on
>> "different first page" so I can start footer on 2nd page?
>
>
> --
> Debra Dalgleish
> Excel FAQ, Tips & Book List
> http://www.contextures.com/tiptech.html
>
>

Thank you Debra. I appreciate your response.

I wonder if it would not be a simple thing for Miscosoft to enable one to do
the same thing in Excel that you can do in Word. I hope they will consider
this possibility.
--
all the easy way of doing things have been taken

dicfor


"Debra Dalgleish" wrote:

> Different first page has always been a feature in Word, but not in Excel.
>
> In Excel, you could print the first page
> Then add the footer, and print the remaining pages.
>
> dicfor wrote:
> > I recently upgraded MS Office. What happened to capability click on
> > "different first page" so I can start footer on 2nd page?
>
>
> --
> Debra Dalgleish
> Excel FAQ, Tips & Book List
> http://www.contextures.com/tiptech.html
>
>

Different first page has always been a feature in Word, but not in Excel.

In Excel, you could print the first page
Then add the footer, and print the remaining pages.

dicfor wrote:
> I recently upgraded MS Office. What happened to capability click on
> "different first page" so I can start footer on 2nd page?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Thank you Debra. I appreciate your response.

I wonder if it would not be a simple thing for Miscosoft to enable one to do
the same thing in Excel that you can do in Word. I hope they will consider
this possibility.
--
all the easy way of doing things have been taken

dicfor


"Debra Dalgleish" wrote:

> Different first page has always been a feature in Word, but not in Excel.
>
> In Excel, you could print the first page
> Then add the footer, and print the remaining pages.
>
> dicfor wrote:
> > I recently upgraded MS Office. What happened to capability click on
> > "different first page" so I can start footer on 2nd page?
>
>
> --
> Debra Dalgleish
> Excel FAQ, Tips & Book List
> http://www.contextures.com/tiptech.html
>
>

Different first page has always been a feature in Word, but not in Excel.

In Excel, you could print the first page
Then add the footer, and print the remaining pages.

dicfor wrote:
> I recently upgraded MS Office. What happened to capability click on
> "different first page" so I can start footer on 2nd page?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Thank you Debra. I appreciate your response.

I wonder if it would not be a simple thing for Miscosoft to enable one to do
the same thing in Excel that you can do in Word. I hope they will consider
this possibility.
--
all the easy way of doing things have been taken

dicfor


"Debra Dalgleish" wrote:

> Different first page has always been a feature in Word, but not in Excel.
>
> In Excel, you could print the first page
> Then add the footer, and print the remaining pages.
>
> dicfor wrote:
> > I recently upgraded MS Office. What happened to capability click on
> > "different first page" so I can start footer on 2nd page?
>
>
> --
> Debra Dalgleish
> Excel FAQ, Tips & Book List
> http://www.contextures.com/tiptech.html
>
>

Different first page has always been a feature in Word, but not in Excel.

In Excel, you could print the first page
Then add the footer, and print the remaining pages.

dicfor wrote:
> I recently upgraded MS Office. What happened to capability click on
> "different first page" so I can start footer on 2nd page?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Thank you Debra. I appreciate your response.

I wonder if it would not be a simple thing for Miscosoft to enable one to do
the same thing in Excel that you can do in Word. I hope they will consider
this possibility.
--
all the easy way of doing things have been taken

dicfor


"Debra Dalgleish" wrote:

> Different first page has always been a feature in Word, but not in Excel.
>
> In Excel, you could print the first page
> Then add the footer, and print the remaining pages.
>
> dicfor wrote:
> > I recently upgraded MS Office. What happened to capability click on
> > "different first page" so I can start footer on 2nd page?
>
>
> --
> Debra Dalgleish
> Excel FAQ, Tips & Book List
> http://www.contextures.com/tiptech.html
>
>

Put this in "ThisWorkbook" Event-code module:

Private Sub Workbook_BeforePrint(Cancel As Boolean)
Const sFOOTER As String = "my footer"
Dim wsSheet As Worksheet
Cancel = True
Application.EnableEvents = False
For Each wsSheet In ActiveWindow.SelectedSheets
With wsSheet
.PageSetup.LeftFooter = ""
.PrintOut from:=1, To:=1
.PageSetup.LeftFooter = sFOOTER
.PrintOut from:=2
End With
Next wsSheet
Application.EnableEvents = True
End Sub


"Debra Dalgleish" <[email protected]> wrote in message
news:[email protected]...
> Different first page has always been a feature in Word, but not in Excel.
>
> In Excel, you could print the first page
> Then add the footer, and print the remaining pages.
>
> dicfor wrote:
>> I recently upgraded MS Office. What happened to capability click on
>> "different first page" so I can start footer on 2nd page?
>
>
> --
> Debra Dalgleish
> Excel FAQ, Tips & Book List
> http://www.contextures.com/tiptech.html
>
>

Thank you Debra. I appreciate your response.

I wonder if it would not be a simple thing for Miscosoft to enable one to do
the same thing in Excel that you can do in Word. I hope they will consider
this possibility.
--
all the easy way of doing things have been taken

dicfor


"Debra Dalgleish" wrote:

> Different first page has always been a feature in Word, but not in Excel.
>
> In Excel, you could print the first page
> Then add the footer, and print the remaining pages.
>
> dicfor wrote:
> > I recently upgraded MS Office. What happened to capability click on
> > "different first page" so I can start footer on 2nd page?
>
>
> --
> Debra Dalgleish
> Excel FAQ, Tips & Book List
> http://www.contextures.com/tiptech.html
>
>

Different first page has always been a feature in Word, but not in Excel.

In Excel, you could print the first page
Then add the footer, and print the remaining pages.

dicfor wrote:
> I recently upgraded MS Office. What happened to capability click on
> "different first page" so I can start footer on 2nd page?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

I recently upgraded MS Office. What happened to capability click on
"different first page" so I can start footer on 2nd page?
--
all the easy way of doing things have been taken

dicfor