Hide and Unhide Sheets automatically

hi team,

my name is elvin and i am new to vba. first of all i would like to introduce my self to you all.

i am a business analyst in my company and i am making reports charts presentation and also making trackers.

i am good with excel by the grace of God.
i havent learnt excel from any institute but i am doing good.

now i want your help in automation my excel with vba code.

i am working on the tracker and it has 7 sheets and 350 employee i have in my office. what i want is when i mail the tracker to the floor and once they enable the macro then automatically the tracker will take their USER ID which is somthing like this (lal00v) and hide and unhide the sheet accordingly.
for agents i have given them level 1 and for team manager level 3 and above team manager level 5 which can access whole tracker.

can anyone help me with this.
i will be highly obliged for you kind help.

Sounds straightforward, but how would we define user levels?

i already defined that because i have their user id through which they login into the system.

can i see an example workbook?

Your OHR lal00v

this should be auto-populate when any one opens the tracker…
5

This is the level which has been define by me to myself.

have u attached the example?

the following Function works on our network to see the login name, I guess it all depends on the type of network and login security you use:

Please Login or Register  to view this content.

There you go. Its a sample sheet of my idea of managing users.

The first sheet which can be hidden contains the users and their levels.
When the code detects a user with access level 2 or higher it asks for password to continue.
For this example the password for level2 is (without quotes) "level 2" and "level 3" for level 3 users.
When a level 1 user logs in only the first sheet is visible
When a level 2 then only the first two sheets.
However when a level 3 user logs in then all worksheets will become visible.
Is this what u want?

oh great ....thats all i wanted......

you have been a great help to me.....

ne more thing i want to ask...is their any way i can learn vba and .net through online...or suggest what should i learn to give wings to my carrer as business analyst.

thanks a lot

This is solved.....however is their any way that system automatically detect the user I'd of the current user.

Which solution worked for you?