Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Password protect from viewing

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default Password protect from viewing

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 19
Default Password protect from viewing

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Password Restrict a Worksheet for Viewing Annie V Setting up and Configuration of Excel 2 September 11th 08 02:52 AM
Password protect an Excel Document from viewing Daisy Excel Discussion (Misc queries) 1 February 9th 07 06:57 PM
VBA password protect brian thompson3001 via OfficeKB.com New Users to Excel 1 July 16th 06 07:23 PM
password protect Jim W via OfficeKB.com Excel Discussion (Misc queries) 2 July 24th 05 12:26 AM
password protect frank Excel Discussion (Misc queries) 2 March 21st 05 06:55 PM


All times are GMT +1. The time now is 05:52 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"