Password to open sheet in workbook

I need a macro which will make password protection to go to certain sheet.
For example, workbook have Sheet1,Sheet2,Sheet3.
Currently i am on Sheet3 and now i am going to Sheet1. Here before i can view sheet1, i need password protection.

Please help

Thank U

Riz Momin

Put this in the codemodule for Sheet1. It should do what you want, but its a big hassle to enter a password everytime you go into a sheet. It might be more userfreindely if you un-commented the okUSER lines and the routine remembered that the user had entered the password.

Please Login or Register  to view this content.

This will work for me...


Thanks a lot


Riz Momin