Turn footer sideways

  • Thread starter Thread starter DFDGirl
  • Start date Start date
D

DFDGirl

Am I able to turn footer sideways like I do when I select a cell and
ask for a -90 percent angle? If not I just need to know. Thank you:)
 
You would have to find or create and then save the pictures as separate files on your computer.
Formats such as .jpg, .gif, .bmp, .png or ?
Vba code would be required to add a particular picture to each page as it was printed.
It could result in a slow printing process.

Example: The following code adds a picture of a padlock to the left footer...
'---
ActiveSheet.PageSetup.LeftFooter = vbNullString
With ActiveSheet.PageSetup.LeftFooterPicture
.Filename = "F:\Icons\vista_toolbar_c\BMP\Lock.bmp"
End With
ActiveSheet.PageSetup.LeftFooter = "&G"
---
Jim Cone
Portland, Oregon USA

..
..
..

"DFDGirl" <[email protected]>
wrote in message
No, but you can insert an image in some xl versions.
--
Jim Cone
Portland, Oregon USAhttp://www.contextures.com/excel-sort-addin.html

.
.
.

"DFDGirl" <[email protected]>
wrote in messageAm I able to turn footer sideways like I do when I select a cell and
ask for a -90 percent angle? If not I just need to know. Thank you:)
Click to expand...

Jim what kind of Image? I am looking to put the Page # on there? Is
there a way to do that in a text box?
 
Further...
I tried a "sideways" font in the footer but it printed conventionally (straight up).
 
Further...
I tried a "sideways" font in the footer but it printed conventionally (straight up).
Click to expand...

Well I appreciate your efforts. I could not get the side printing to
work either. Thank you.
 
Hi DFD,

Maybe you can use my idea, set ur View into a "Page Break View" then
merge each last coloumn, for the first column use Ctrl+1 (Format
Cell), then go to NUMBER TAB in CATEGORY=Costum, in TYPE just type...

"(Text) Page"0

Then in ALIGNMENT TAB, Horizontal=Center, Vertical=Center, Degrees is
90, Then enter.

Copy the first page last column into next page last column, then use
this formula =i1+1 (lets assume ur "i1" is ur last column in page#1.
Then do it into ur next page so forth and so on........

This one does not need some HeadAche codes but it works, need only to
copy those columns into next.

Hope this will help, hehe!
~jaeson
 
Back
Top