USerId and password to access a WB

sujittalukde

Well-known Member
Joined
Jun 2, 2007
Messages
520
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.
 

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

Stormseed

Banned
Joined
Sep 18, 2006
Messages
3,274
Open the file for which you want password enabled -->Select File menu option --> Save As--> In the window click on Tools --> General Options.
 

Stormseed

Banned
Joined
Sep 18, 2006
Messages
3,274
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

Well-known Member
Joined
Jun 2, 2007
Messages
520
Would this not be done through macro?
 

cata2200

Board Regular
Joined
Jul 29, 2006
Messages
60
user: Peter Arnett
Pwd: Alison

Is written in code.

Regards. Catalin
 

sujittalukde

Well-known Member
Joined
Jun 2, 2007
Messages
520
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

Well-known Member
Joined
Jun 2, 2007
Messages
520
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.
 

Forum statistics

Threads
1,181,102
Messages
5,928,062
Members
436,586
Latest member
latintxn

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top