| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Function "User()" to provide access to workbook
Using WindowsXP_OS and Office 97 (Excel 97)...
I've created a function in a module and set cell A1 to "=User()" This provides the user name within this cell. I want to be able to lookup the user name within this cell and providing the user is authorised to use the workbook then they can proceed, otherwise I want excel to close the workbook. Eg. Jim Smith OK to use Fred Bloggs OK to use Any other user exit excel Any Help would be a great help!!!!! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Function "User()" to provide access to workbook
I have only used this on Windows NT logged onto a LAN to get the users
ID ,so I do not know if it will work in your situation UserName = Environ$("UserName") --- Message posted from http://www.ExcelForum.com/ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Shared Workbook is "in use by another user" | Excel Discussion (Misc queries) | |||
| User created function not "updating" | Excel Worksheet Functions | |||
| Is there a "last saved on date/user" macro/function for Excel 2003 | Excel Discussion (Misc queries) | |||
| Provide list from all columns marked with and "x" | Excel Worksheet Functions | |||
| Password-Protected Workbook not showing "in use by another user" | Excel Discussion (Misc queries) | |||
![Wayne[_5_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
