Footers

2077delta · Mar 18th, 2002, 02:26 PM

Is it possible to print the left, center and right aligned footers in separate colors?

Al Chara · Mar 18th, 2002, 02:39 PM

As far as I know, no. But maybe someone else in here knows.

Jack in the UK · Mar 18th, 2002, 03:36 PM

Hi Guys

I loved the question, spend time on this No ican solve this one..

Hope someone can, im intrested

Juan Pablo González · Mar 18th, 2002, 07:57 PM

The PageSetup object is not the best object in VBA. I think the only solution for this would be to "simulate" footers in the sheet.

Mar 18th, 2002, 03:36 PM	#3
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	Hi Guys I loved the question, spend time on this No ican solve this one.. Hope someone can, im intrested __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Mar 18th, 2002, 07:57 PM	#4
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,927	The PageSetup object is not the best object in VBA. I think the only solution for this would be to "simulate" footers in the sheet. __________________ Regards, Juan Pablo González http://www.juanpg.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 18th, 2002, 02:26 PM	#1
2077delta Board Regular Join Date: Feb 2002 Posts: 217	Is it possible to print the left, center and right aligned footers in separate colors?

Mar 18th, 2002, 02:39 PM	#2
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	As far as I know, no. But maybe someone else in here knows.