Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a workbook that contains multiple worksheets. I want a particular
people to be able to view and edit one specific worksheet, and not be able to see any of the other worksheets. Is there a way to set up a password for specific worksheets? For example, I'd call one worksheet William, and another Thomas. I'd then give Bill the password to the worksheet called William, but he would not be able to see the workheet called Thomas. -- JLevine |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
It is possible but involves a whole lot of VBA code to hide sheets and
arrange passwords or login names for each user. Also a contingency plan if users decide to disable macros when opening the workbook. You also have the weakness of Excel's internal security to deal with and hiding the code from prying eyes. It would probably be easier to just give each user his/her own workbook with just the one sheet. If you want to use the multi-sheet password method see this thread. http://tinyurl.com/ysj6dw Gord Dibben MS Excel MVP On Wed, 5 Nov 2008 06:40:17 -0800, levine52 wrote: I have a workbook that contains multiple worksheets. I want a particular people to be able to view and edit one specific worksheet, and not be able to see any of the other worksheets. Is there a way to set up a password for specific worksheets? For example, I'd call one worksheet William, and another Thomas. I'd then give Bill the password to the worksheet called William, but he would not be able to see the workheet called Thomas. |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
JLevine. In a way, Gord it is right, but it is not as hard as he put it.
Following the descrition of what you said, here is what you need to do: 1- In the same workbook, create a sheet called Tables. 2- Create a table that only you will be able to see and manage. 3- Everything from this point on, is VB with macros. No choice. 4- The table has to read something like: - Record No - Password - User - Department (For Control Purpose) - Authorize User Sheet - This field would identify the spreadsheet that this user can access. In some cases, you may have users accesing more than one sheet, then the program has to go over all fields and identify which sheet(s) can a specific user open. Suggestion, if any user is authorized to see al spreadsheets, then in the Authorize User Sheet fiel = ALL. So if the program read that with the current pasword can abort the Function and go and open all sheets for that user. 5- Every area, or potential user must request access to the file in a formal manner 6- La Macro will have to read something like this: - Declare a Dim(X) to load all the sheets a user can see - Unprotect or make visible all Xs that have been loaded in the Dim(X) 7- If the file is only for reading purposes for everybody, then you don't have to worry about conflicts for using the file at the same time for several users. If they need to update the file, then, the file must be allocated to the user and advise that the file is in use, so the new user know who has it and can wait until it is release; this piece is managed authomatically by Windows. 8- In the Woorkbook tab, inside the VB, you should define a short macro that forces the file to be save every time the file has been close. This will avoid any lost data. I did this back in 2002/2003 for a very complex project. I know that it works. My advise is not to be discourage by the challenge and keep trying until you get it. If you want to get quick there, then perhaps you can see who has the VB skills that can help you. By the way, I don't recall that this is a lot of coding, I think it may be about three to four Functions and those are not longer that 10-15 lines of code. I would love to help you now, but since I have no being programing for a while, I would have to find my files and that is going to take some time. If you have not found a solution in three weeks and still need it, let me know and then I will try to find them. I hope this helps. Argy "Gord Dibben" wrote: It is possible but involves a whole lot of VBA code to hide sheets and arrange passwords or login names for each user. Also a contingency plan if users decide to disable macros when opening the workbook. You also have the weakness of Excel's internal security to deal with and hiding the code from prying eyes. It would probably be easier to just give each user his/her own workbook with just the one sheet. If you want to use the multi-sheet password method see this thread. http://tinyurl.com/ysj6dw Gord Dibben MS Excel MVP On Wed, 5 Nov 2008 06:40:17 -0800, levine52 wrote: I have a workbook that contains multiple worksheets. I want a particular people to be able to view and edit one specific worksheet, and not be able to see any of the other worksheets. Is there a way to set up a password for specific worksheets? For example, I'd call one worksheet William, and another Thomas. I'd then give Bill the password to the worksheet called William, but he would not be able to see the workheet called Thomas. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Password Restrict a Worksheet for Viewing | Setting up and Configuration of Excel | |||
Password protect an Excel Document from viewing | Excel Discussion (Misc queries) | |||
VBA password protect | New Users to Excel | |||
password protect | Excel Discussion (Misc queries) | |||
password protect | Excel Discussion (Misc queries) |