LinkBack URL
About LinkBacks
I have two userforms and I would like to open one or the other of the userforms based on the username opening the file. Is this possible?
I have two userforms and I would like to open one or the other of the userforms based on the username opening the file. Is this possible?
In the ThisWorkbook code page.
Private Sub Workbook_Open() Select Case Application.UserName Case "Me" Userform1.Show Case "You" Userform2.Show End Select End Sub
David
(*) Reputation points appreciated.
Are the userforms for different tasks? If nit why have two userforms?
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks