#1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 21
Default Userid

I need to determine the Windows login ID of my current user to determine
whether (s)he is authorized to execute certain macros. How would I get that
information programmatically?

Thanks
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Userid

You can get that by executing this function call within your code...

Environ("USERNAME")

Rick


"Marvin Buzz" wrote in message
...
I need to determine the Windows login ID of my current user to determine
whether (s)he is authorized to execute certain macros. How would I get
that
information programmatically?

Thanks


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 124
Default Userid

Hi there,

Ken Puls has a great write-up on his site with examples, full code and
pictures...

http://excelguru.ca/node/2

HTH

--
Zack Barresse



"Marvin Buzz" wrote in message
...
I need to determine the Windows login ID of my current user to determine
whether (s)he is authorized to execute certain macros. How would I get
that
information programmatically?

Thanks


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
userid in macro mmccoog Excel Programming 6 September 26th 07 02:22 PM
Userid Marvin Excel Programming 4 March 14th 07 07:55 PM
Log UserID JJ Excel Programming 3 March 9th 05 01:30 PM
DSN UserId and Password Prompt bslater[_13_] Excel Programming 0 September 22nd 04 09:02 PM
DSN UserId and Password Prompt bslater[_12_] Excel Programming 1 September 22nd 04 08:30 PM


All times are GMT +1. The time now is 10:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"