software

Hi - I am trying to add a quot;saved byquot; type of field to a custom footer in
Excel 2003. What I want is a document to print with footers that say who has
modified it last among some other fields. I was wondering if somewhere there
is a list of all the field codes (like quot;$[code]quot;) available beyond what icons
you can click on when you open the custom footer dialog. I thought I saw a
list before in help on Excel but I can't find it again. I just want to be
able to write in new field codes for printing custom footers, and want more
complicated field codes than the 6 or 8 that Excel gives me automatically.

Also, is there a way to apply a footer made in one sheet to all sheets? I
have a lot of sheets in one book and don't want to repeat my entry.

Thanks!

There is no field code that I am aware of to enter the user name in a
header or footer. A macro would be necessary. The following are the
codes that can be used when writing a macro.
Some, maybe all appear to work when entered manually.

The macro code for a user name would look something like...
ActiveSheet.PageSetUp.LeftFooter = Application.UserName
--
Jim Cone
San Francisco, USA
www.realezsites.com/bus/primitivesoftwareCode Description
amp;L Left aligns the characters that follow.
amp;C Centers the characters that follow.
amp;R Right aligns the characters that follow.
amp;E Turns double-underline printing on or off.
amp;X Turns superscript printing on or off.
amp;Y Turns subscript printing on or off.
amp;B Turns bold printing on or off.
amp;I Turns italic printing on or off.
amp;U Turns underline printing on or off.
amp;S Turns strikethrough printing on or off.
amp;D Prints the current date.
amp;T Prints the current time.
amp;F Prints the name of the document.
amp;A Prints the name of the workbook tab.
amp;P Prints the page number.
amp;P number Prints the page number plus the specified number.
amp;P-number Prints the page number minus the specified number.
amp;amp; Prints a single ampersand.
amp;N Prints the total number of pages in the document.
amp; quot;fontnamequot; Prints the characters that follow in the specified font.
Be sure to include the double quotation marks.
amp;nn Prints the characters that follow in the specified font size.
Use a two-digit number to specify a size in points.
'---------------------quot;SS.Minnowskiquot; gt;
wrote in message
Hi - I am trying to add a quot;saved byquot; type of field to a custom footer in
Excel 2003. What I want is a document to print with footers that say who has
modified it last among some other fields. I was wondering if somewhere there
is a list of all the field codes (like quot;$[code]quot;) available beyond what icons
you can click on when you open the custom footer dialog. I thought I saw a
list before in help on Excel but I can't find it again. I just want to be
able to write in new field codes for printing custom footers, and want more
complicated field codes than the 6 or 8 that Excel gives me automatically.

Also, is there a way to apply a footer made in one sheet to all sheets? I
have a lot of sheets in one book and don't want to repeat my entry.

Thanks!


Is there a way to adjust the spacing of text in a header field?

I am trying to set a 3 line right header and would like the entries to
appear left justified (on the right side of the page). I can't use the
amp;L because it moves everything completely to the left header.

What I have

Date 04/20/2006
Order# 12345
Recieved 03/01/2006

I would like this header to appear like this:

Date 04/20/2006
Order# 12345
Recieved 03/01/2006

but at the right of the page
Any suggestions?

Thanks--
bhofsetz
------------------------------------------------------------------------
bhofsetz's Profile: www.excelforum.com/member.php...oamp;userid=18807
View this thread: www.excelforum.com/showthread...hreadid=533971Not that I know of. You can fudge it by using spaces followed by a period.
Also, quot;iquot; before quot;equot; except after quot;cquot;.
Jim Conequot;bhofsetzquot;
wrote in message
Is there a way to adjust the spacing of text in a header field?
I am trying to set a 3 line right header and would like the entries to
appear left justified (on the right side of the page). I can't use the
amp;L because it moves everything completely to the left header.

What I have

Date 04/20/2006
Order# 12345
Recieved 03/01/2006

I would like this header to appear like this:

Date 04/20/2006
Order# 12345
Recieved 03/01/2006

but at the right of the page
Any suggestions?

Thanks--
bhofsetz
------------------------------------------------------------------------
bhofsetz's Profile: www.excelforum.com/member.php...oamp;userid=18807
View this thread: www.excelforum.com/showthread...hreadid=533971
Thanks for the tip Jim.

I had already tried using spaces followed by a period but didn't want
the period to show when printed. Therefore I changed the font size of
the period with amp;01 which works but then for subsequent lines the font
size has to be changed back, etc. This makes what should be a fairly
simple header into a mess, plus I'm running out of the 255 characters
Excel allows you for the header since there are other entries in the
left and center sections.

So I was hoping there would be a simpler way to do this with.

An unrelated website I found interesting.
alt-usage-english.org/I_before_E.html--
bhofsetz
------------------------------------------------------------------------
bhofsetz's Profile: www.excelforum.com/member.php...oamp;userid=18807
View this thread: www.excelforum.com/showthread...hreadid=533971