Passwrods
Hi,
Is it possible to allow a user to enter their pin number and password in order to generate a table of results unique to that user. The idea is that each user can only view their own summary of performance. There are some 500 users of this and it is not practicable to give them all a unique workbook for themselves. Mickey |
Passwrods
You could use
Environ("UserName") Which returns the name of the user currently logged in to the system. Based on that you will know who you are dealing with and can display only the info they are authorized to view... HTH "MBlake" wrote: Hi, Is it possible to allow a user to enter their pin number and password in order to generate a table of results unique to that user. The idea is that each user can only view their own summary of performance. There are some 500 users of this and it is not practicable to give them all a unique workbook for themselves. Mickey |
Passwrods
Hi Jim,
Can you explain how I use this?. I entered <Environ("UserName") into a cell but got just the printed text. I entered it as =Environ("UserName") and got NAME? Mickey |
Passwrods
This is a VBA method, not a worksheet function. To get this into a
worksheet fucntion, you can use something like this ... http://www.vbaexpress.com/kb/getarticle.php?kb_id=234 Making use of the UDF in the link, you could use the worksheet function ... =GetName("Windows") HTH, and regards, Zack Barresse "MBlake" wrote in message ... Hi Jim, Can you explain how I use this?. I entered <Environ("UserName") into a cell but got just the printed text. I entered it as =Environ("UserName") and got NAME? Mickey |
All times are GMT +1. The time now is 11:29 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com