asked on
VBA apply printing properties in some sheets of the worksheet- not all
I have some sheets, not all the sheets of the workbook that i have to change the header and footer. My code it does well but is very long, I am sure that there is a way to make it more symple, but I don't know how to do it.
My code is:
Sheets("index").Select
With ActiveSheet.PageSetup
.LeftHeader = ""
.CenterHeader = ""
.RightHeader = ""
.LeftFooter = "&D"
.CenterFooter = ""
.RightFooter = "&P/&N"
End With
Sheets("PiG").Select
With ActiveSheet.PageSetup
.LeftHeader = ""
.CenterHeader = ""
.RightHeader = ""
.LeftFooter = "&D"
.CenterFooter = ""
.RightFooter = "&P/&N"
End With
Sheets("Detall despeses").Select
With ActiveSheet.PageSetup
.LeftHeader = ""
.CenterHeader = ""
.RightHeader = ""
.LeftFooter = "&D"
.CenterFooter = ""
.RightFooter = "&P/&N"
End With
Sheets("Punt mort").Select
With ActiveSheet.PageSetup
.LeftHeader = ""
.CenterHeader = ""
.RightHeader = ""
.LeftFooter = "&D"
.CenterFooter = ""
.RightFooter = "&P/&N"
End With
Sheets("BalançC").Select
With ActiveSheet.PageSetup
.LeftHeader = ""
.CenterHeader = ""
.RightHeader = ""
.LeftFooter = "&D"
.CenterFooter = ""
.RightFooter = "&P/&N"
End With
Sheets("EOAF").Select
With ActiveSheet.PageSetup
.LeftHeader = ""
.CenterHeader = ""
.RightHeader = ""
.LeftFooter = "&D"
.CenterFooter = ""
.RightFooter = "&P/&N"
End With
Sheets("Anàlisi financera").Select
With ActiveSheet.PageSetup
.LeftHeader = ""
.CenterHeader = ""
.RightHeader = ""
.LeftFooter = "&D"
.CenterFooter = ""
.RightFooter = "&P/&N"
End With
Sheets("Anàlisi rendibilitat").Select
With ActiveSheet.PageSetup
.LeftHeader = ""
.CenterHeader = ""
.RightHeader = ""
.LeftFooter = "&D"
.CenterFooter = ""
.RightFooter = "&P/&N"
End With
Sheets("Anàlisi gestió").Select
With ActiveSheet.PageSetup
.LeftHeader = ""
.CenterHeader = ""
.RightHeader = ""
.LeftFooter = "&D"
.CenterFooter = ""
.RightFooter = "&P/&N"
End With
Sheets("Detall Immobilitzat").Select
With ActiveSheet.PageSetup
.LeftHeader = ""
.CenterHeader = ""
.RightHeader = ""
.LeftFooter = "&D"
.CenterFooter = ""
.RightFooter = "&P/&N"
End With
Sheets("Detall Entitats Públiques").Select
With ActiveSheet.PageSetup
.LeftHeader = ""
.CenterHeader = ""
.RightHeader = ""
.LeftFooter = "&D"
.CenterFooter = ""
.RightFooter = "&P/&N"
End With
Sheets("Càlcul Impost S.").Select
With ActiveSheet.PageSetup
.LeftHeader = ""
.CenterHeader = ""
.RightHeader = ""
.LeftFooter = "&D"
.CenterFooter = ""
.RightFooter = "&P/&N"
End With
Sheets("Informació complementaria").Select
With ActiveSheet.PageSetup
.LeftHeader = ""
.CenterHeader = ""
.RightHeader = ""
.LeftFooter = "&D"
.CenterFooter = ""
.RightFooter = "&P/&N"
End With
Sheets("Resultat-socis").S
With ActiveSheet.PageSetup
.LeftHeader = ""
.CenterHeader = ""
.RightHeader = ""
.LeftFooter = "&D"
.CenterFooter = ""
.RightFooter = "&P/&N"
End With
My code is:
Sheets("index").Select
With ActiveSheet.PageSetup
.LeftHeader = ""
.CenterHeader = ""
.RightHeader = ""
.LeftFooter = "&D"
.CenterFooter = ""
.RightFooter = "&P/&N"
End With
Sheets("PiG").Select
With ActiveSheet.PageSetup
.LeftHeader = ""
.CenterHeader = ""
.RightHeader = ""
.LeftFooter = "&D"
.CenterFooter = ""
.RightFooter = "&P/&N"
End With
Sheets("Detall despeses").Select
With ActiveSheet.PageSetup
.LeftHeader = ""
.CenterHeader = ""
.RightHeader = ""
.LeftFooter = "&D"
.CenterFooter = ""
.RightFooter = "&P/&N"
End With
Sheets("Punt mort").Select
With ActiveSheet.PageSetup
.LeftHeader = ""
.CenterHeader = ""
.RightHeader = ""
.LeftFooter = "&D"
.CenterFooter = ""
.RightFooter = "&P/&N"
End With
Sheets("BalançC").Select
With ActiveSheet.PageSetup
.LeftHeader = ""
.CenterHeader = ""
.RightHeader = ""
.LeftFooter = "&D"
.CenterFooter = ""
.RightFooter = "&P/&N"
End With
Sheets("EOAF").Select
With ActiveSheet.PageSetup
.LeftHeader = ""
.CenterHeader = ""
.RightHeader = ""
.LeftFooter = "&D"
.CenterFooter = ""
.RightFooter = "&P/&N"
End With
Sheets("Anàlisi financera").Select
With ActiveSheet.PageSetup
.LeftHeader = ""
.CenterHeader = ""
.RightHeader = ""
.LeftFooter = "&D"
.CenterFooter = ""
.RightFooter = "&P/&N"
End With
Sheets("Anàlisi rendibilitat").Select
With ActiveSheet.PageSetup
.LeftHeader = ""
.CenterHeader = ""
.RightHeader = ""
.LeftFooter = "&D"
.CenterFooter = ""
.RightFooter = "&P/&N"
End With
Sheets("Anàlisi gestió").Select
With ActiveSheet.PageSetup
.LeftHeader = ""
.CenterHeader = ""
.RightHeader = ""
.LeftFooter = "&D"
.CenterFooter = ""
.RightFooter = "&P/&N"
End With
Sheets("Detall Immobilitzat").Select
With ActiveSheet.PageSetup
.LeftHeader = ""
.CenterHeader = ""
.RightHeader = ""
.LeftFooter = "&D"
.CenterFooter = ""
.RightFooter = "&P/&N"
End With
Sheets("Detall Entitats Públiques").Select
With ActiveSheet.PageSetup
.LeftHeader = ""
.CenterHeader = ""
.RightHeader = ""
.LeftFooter = "&D"
.CenterFooter = ""
.RightFooter = "&P/&N"
End With
Sheets("Càlcul Impost S.").Select
With ActiveSheet.PageSetup
.LeftHeader = ""
.CenterHeader = ""
.RightHeader = ""
.LeftFooter = "&D"
.CenterFooter = ""
.RightFooter = "&P/&N"
End With
Sheets("Informació complementaria").Select
With ActiveSheet.PageSetup
.LeftHeader = ""
.CenterHeader = ""
.RightHeader = ""
.LeftFooter = "&D"
.CenterFooter = ""
.RightFooter = "&P/&N"
End With
Sheets("Resultat-socis").S
With ActiveSheet.PageSetup
.LeftHeader = ""
.CenterHeader = ""
.RightHeader = ""
.LeftFooter = "&D"
.CenterFooter = ""
.RightFooter = "&P/&N"
End With
Microsoft Excel
Last Comment
Norie
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thankyou it works ok, I didn't know how to do it
I actually expected you to ask in the other question, which is still open.
ASKER
Help IMnorie, I have already realized that I have test it in a excel that I have already taquen out the headers, now I try to do it again in one that has the logos and it does not work, I do not understand why.
One question, do I have to initialize arrShts value?
One question, do I have to initialize arrShts value?
ASKER
OK
Yes you need to declare arrShts like this.
How does the code not work?
Does it work for the code you posted but not for some other code?
Dim arrShts
How does the code not work?
Does it work for the code you posted but not for some other code?
ASKER
Hi Imnorie,
I must apologize, it seems that today I am a little bit stupid. I put your code in the wrong position in the new sheet, I have tested again and it works perfectly, sorry.
By the way, I am new in this system, I don't know what I have to do with the other question? How I have to close it?
I must apologize, it seems that today I am a little bit stupid. I put your code in the wrong position in the new sheet, I have tested again and it works perfectly, sorry.
By the way, I am new in this system, I don't know what I have to do with the other question? How I have to close it?
Not sure which one you mean.
You definitely closed one of them, I think you might even have given me some points.
Isn't there a button you can click to close a question and allocate points?
You definitely closed one of them, I think you might even have given me some points.
Isn't there a button you can click to close a question and allocate points?