Thread: Log in userform
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mas Mas is offline
external usenet poster
 
Posts: 3
Default Log in userform

Hi all,

I have created a userform for my workbook that when you open the
workbook the form appears.

I am not sure how to have it so the worksheets stay hidden until a
username and password is entered and the only display the worksheet(s)
for that username.

For example: username: user2 only displays worksheet titled "user2"
while all other worksheets stay hidden.

Or if it is easier, after the user logs in, a menu appears based on
username for worksheets that are assessible to the individual user.

I appreciate any help you can give me.