Concluído

Troubleshoot Excel Macro to Print Custom Header on 1st Page Only

I’m looking for a coder who can start on (and finish) this immediately.

I have an Excel spreadsheet that has a custom header. I want the custom header to print only on page 1 of a 2 page spreadsheet. When I run the macro I have, it wipes out the custom header.

Also, I want page 2 to start printing at 1/2?? down from the top of the paper. Currently, my top margin is set to 2.5?? to allow room for the header to print on page 1.

Here is the macro (you can use your own macro):

Public Sub FirstPageHeaderOnly_AllSheets()

Dim wsSheet As Worksheet

Dim sHeader As String

For Each wsSheet In Worksheets

With wsSheet

sFooter = .[url removed, login to view]

.PrintOut From:=1, To:=1

.[url removed, login to view] = ""

.PrintOut From:=2

.[url removed, login to view] = sHeader

End With

Next wsSheet

End Sub

(it's not really spread out like that)

Attached is the spreadsheet.

Thanks for bidding!

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

Excel

Habilidades: Vale Tudo, Engenharia, MySQL, PHP, Arquitetura de software, Teste de Software, Hospedagem Web, Gestão de Site , Teste de Website

Veja mais: web page spreadsheet, spreadsheet on web page, print out source, print hire, excel out source, custom coder to hire, 1st source, troubleshoot, ready to print, print only, hire macro coder, software engineering paper, excel macro program, php macro, macro spreadsheet, php excel macro, margin spreadsheet, excel macro php, php printout, excel macro source code

Acerca do Empregador:
( 210 comentários ) Arden, United States

ID do Projeto: #3917774

Concedido a:

devdive

See private message.

$2 USD em 1 dia
(28 Comentários)
3.4