USerId and password to access a WB

[sujittalukde]

I have made an excel file the use of which I want to restrict to a few people. So I want that whenever the user will open the file it will prompt for user id and password. If these matches then he will be allowed to access the file. Thre types of user id and password is required:

User! : Can modify, edit, delete, etc ie full access (Adminstrator type)
User2: Only access to print (no entry,edit,modifiaction,etc)
User3: Only be able to see the file and no print,entry,etc access.

If all are not possible, then provide code for part.

Macro will always be enabled as I found code on the net to force user to enable macro. ie if macros are not enabled, it shows another rough page. So enabling macro is not a problem.

 

[Stormseed]

Open the file for which you want password enabled -->Select File menu option --> Save As--> In the window click on Tools --> General Options.

 

[sujittalukde]

How can I use the same for User2 & User3?

 

[Stormseed]

How can I use the same for User2 & User3?

you cannot for different users. This is the only option available in Excel and is by design. I dunno if you can do it with a third party software.

 

[sujittalukde]

Would this not be done through macro?

 

[royUK]

You would need a VBA solution. see the final example here

http://www.ozgrid.com/forum/showthread.php?t=31194

 

[sujittalukde]

Thanks royuk, I serached the other posts also there and found one thread and found good one but the code is provided at the attached WB and the w\code is password protected. Could you provide the pwd? Link is
http://www.ozgrid.com/forum/showthread.php?t=22514

 

[cata2200]

user: Peter Arnett
Pwd: Alison

Is written in code.

Regards. Catalin

 

[sujittalukde]

it is not matching Also for VBA password, no user id is thre. I am talking about the att made by royuk at that post

 

[sujittalukde]

Any help please
Actually my need is multi user level password which will restrict some users from some features as set in my first post.