Excel Passwords

Donald

Board Regular
Joined
Apr 15, 2002
Messages
138
If I have an Excel Workbook and I have six people sharing the same workbook, is there any way I can set permissions so they each control certain pieces of the workbook so the objective is when one person is in the workbook he or she can only change her info and not others.
 

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

JazzSP8

Well-known Member
Joined
Sep 30, 2005
Messages
1,223
Office Version
  1. 2013
  2. 2010
Platform
  1. Windows
If its shared over a network then you could look into protecting or unprotecting certain worksheets based on the username, something along the lines of;

Code:
Dim User As String
User = Environ("username")
If User = "JazzSP8" Then
Sheet1.Unprotect (PASSWORD)
Sheet2.Protect (PASSWORD)
End If

Place something like that the ThisWookbook module, it works for me on one of my spreadsheets... :)
 

Peter1973

Well-known Member
Joined
May 13, 2006
Messages
934
Looked at this and it look slike something that would be very usefull but not too good on vba any chance you could explain why it works ive tried copying it in but not worknig. Does it ony work on a network ?
 

Forum statistics

Threads
1,141,587
Messages
5,707,252
Members
421,498
Latest member
matinebi

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