Posted to microsoft.public.excel.programming

Donald[_4_] Donald[_4_] is offline

external usenet poster

Posts: 11

Programming footer

The following code will programmatically add the user's name as well as date
and time to the right footer as well as setting the fonts of both lines in
the footer.

ActiveSheet.PageSetup.RightFooter = _
"&""Brush Script mt,italic""&14" & Application.UserName & _
Chr(10) & "&""Times New Roman""&8" & "&D &T"

How do I get it to underline the user name? (only the user name)

--
D.S.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel footer to look like Word footer?	Carole O	Excel Discussion (Misc queries)	5	June 2nd 08 11:25 PM
Programming help	BB	Excel Discussion (Misc queries)	3	December 5th 05 01:09 AM
Programming to VBE	Ron de Bruin	Excel Programming	1	September 15th 04 07:51 PM
Programming lag	Ernst Guckel[_3_]	Excel Programming	4	June 9th 04 03:40 PM
Landscape Orientation when Footer set using mso-footer-data Disappear	Vish[_2_]	Excel Programming	0	November 14th 03 09:28 PM

All times are GMT +1. The time now is 01:54 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us