Function "User()" to provide access to workbook

W

Wayne

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!!!!!
 
M

mudraker

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")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

User Defined Function being called by changes to an independent workbook 13
Determine if workbook is open 2
Last Modified By in a cell by user 3
Excel Function not Evaluating to a Result 1
Excel Providing user message when RED X clicked & properly closing application. 2
COUNTIF calculations & Two-way Lookup 2
Open Workbook Macro - with a twist 1
defign a function in one workbook and use it in another workbook 3

Top