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.

 

[Krishnakumar]

Hi,

You could download another one from here

HTH

 

[sujittalukde]

Thanks kris but this is equal to first reply to the post. My need is multilevel user ie all the users will be able to make entry but different users will have different access

User ! All access
User 2 Only print access, no editing, entry etc.

Can this be done in excel?

 

[sujittalukde]

Please help!

 

[Krishnakumar]

Thanks kris but this is equal to first reply to the post. My need is multilevel user ie all the users will be able to make entry but different users will have different access

User ! All access
User 2 Only print access, no editing, entry etc.

Can this be done in excel?

Check the link above. A new version added there.

 

[sujittalukde]

Thanks Kris many many thanks I really appreciate your hard work. THis one is perfect and what I was looking for.

 

[Krishnakumar]

Thanks Kris many many thanks I really appreciate your hard work. THis one is perfect and what I was looking for.

You are welcome!!

 

[2001jonathon]

Is there a way to turn off the control c command as well as the print screen to lock the think up from printing for good.