How do I automatically insert the user (login name) in Excel?

#1 September 19th, 2005, 01:42 AM

I want to insert the currently logged on username in an Excel worksheet. I
would like it to appear in the footer. I have selected one of the footer
options showing what I thought was a username and it works on my PC only.
When another user opens the template on their PC, my name still appears in
the footer. I want the username to change depending on who opens the
template.

#2 September 19th, 2005, 02:48 AM

Try one of these methods:
http://vbaexpress.com/kb/getarticle.php?kb_id=768
************
Anne Troy
www.OfficeArticles.com

"ABlazer" wrote in message
...
I want to insert the currently logged on username in an Excel worksheet. I
would like it to appear in the footer. I have selected one of the footer
options showing what I thought was a username and it works on my PC only.
When another user opens the template on their PC, my name still appears in
the footer. I want the username to change depending on who opens the
template.

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Corrupt Windows Componenet, or Outlook Problem?	BPC23 com>	General Discussion	0	May 27th, 2005 06:08 PM
Using Windows Login to determine Access User	CSML	General Discussion	1	April 25th, 2005 09:04 PM
Login forms	John Jenkins	Using Forms	5	March 31st, 2005 08:09 PM
How do I insert a calendar as a form field for the user to choose.	Patty	General Discussion	1	January 27th, 2005 02:48 AM
Columns and layout problems	Phil	Setting Up & Running Reports	4	August 18th, 2004 01:34 PM