Security 101 or Recognize User

[yippie_ky_yay]

Hello group,

to help me plan, I created a startup sheet with two buttons labeled "User" and "Manager" (the User view will hide certain sheets to avoid confusion).

This is obviously a primitive solution and was wondering if there was a way for Excel (97)or the VBA to be able to check to see who the user is (I had no luck with Application.UserName because it just returns the organization's name).

Any help would be greatly appreciated!

-Sean
This message was edited by yippie_ky_yay on 2002-09-25 05:50

 

[royUK]

Checkout
http://www.ozgrid.com/Excel/2home.htm

There is a workbook example to assign usernames and passwords to workbooks

 

[yippie_ky_yay]

Thanks Roy! Exactly what I was looking for!

-Sean