Allowing users to view multiple sheets once signed in

[helpmyexcel]

Hello All,

I'm brand new to the forum. I have searched other posts about this but can not find a solution. I am having difficulty making this work...and I am gettin frustrated !!!!!

What i am trying to do: Create a login option to filter what worksheets each user can see. I need the users to be able to view 2 sheets not just 1. Also i need an admin login that can view all sheets. I want to keep the workbook protected so even though they can see and edit those two sheets they can only edit certain unlocked cells. Admin should be able to view/edit all cells on all sheets.

Below is my code which is made for a sample workbook. I was just trying to get the concept down adn then i would convert it to the real workbook.

Can someone please help!

Form Code:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Macro:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[alansidman]

Code Tags Added
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between

Please Login or Register  to view this content.

tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



(Because you are new to the forum, I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)

[helpmyexcel]

thank you. but since you know so much, cant you help me out ?????