Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table limiting user selection
Hi,
I have a pivot table with different region and different Operational Directors' performance. I would like to limit the user to their own data without seeing others' numbers. How would I do that? For example, let say, there are 3 operational directors A, B and C, if person A opens the spreadsheet, is it possible for him/her to enter a password to access his/her info only? thanks, PJS |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table limiting user selection
While this is possible via VB, to set something up so that certain sheets
are hidden/displayed when the correct password is given, note that this is by no means secure. If Director A "really" wants to see the other directos reports, you won't be able to stop them unless the data is physically seperated. XL is just simply not built to provide that type of secure functionality. Further detail: Many people think that sheet/worksheet protection offers them security. It doesn't, is simply offers structure/data protection in that sense that you don't accidentally overwrite it. The classic code to crack those interal codes can be found he http://www.mcgimpsey.com/excel/removepwords.html Further, the passwords used to open XL, or the code itself, can be cracked with several 3rd party applications. In summary, if you're wanting to create different views of data for convenience, go ahead and put it all in one workbook and set up some custom passwords and such. If you're looking for security on sensitive data (salary, performance review, etc) use seperate workbooks. -- Best Regards, Luke M "PJS" wrote in message ... Hi, I have a pivot table with different region and different Operational Directors' performance. I would like to limit the user to their own data without seeing others' numbers. How would I do that? For example, let say, there are 3 operational directors A, B and C, if person A opens the spreadsheet, is it possible for him/her to enter a password to access his/her info only? thanks, PJS |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table limiting user selection
Hi,
you will need to set up a diferent worksheet for each director, then hide the worksheet, but before hidding it, right click on the mouse view code, coppy this, the password used is called Manager, change it for yours, there are three places where the password is mentioned Private Sub Worksheet_Activate() Dim strPassword As String On Error Resume Next Me.Protect Password:="MANAGER" Me.Columns.Hidden = True strPassword = InputBox("Enter password to access DATA sheet") If strPassword = "" Then ActiveSheet.Visible = False Worksheets("Menu").Select Exit Sub ElseIf strPassword < "MANAGER" Then MsgBox "Password Incorrect " ActiveSheet.Visible = False Worksheets("Menu").Select Exit Sub Else Me.Unprotect Password:="MANAGER" Me.Columns.Hidden = False End If Range("a1").Select On Error GoTo 0 End Sub Private Sub Worksheet_Deactivate() On Error Resume Next Me.Columns.Hidden = True On Error GoTo 0 End Sub "PJS" wrote: Hi, I have a pivot table with different region and different Operational Directors' performance. I would like to limit the user to their own data without seeing others' numbers. How would I do that? For example, let say, there are 3 operational directors A, B and C, if person A opens the spreadsheet, is it possible for him/her to enter a password to access his/her info only? thanks, PJS |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Limiting selection in a cell AND linking that selection to a list | Excel Discussion (Misc queries) | |||
Pivot Table Selection | Excel Discussion (Misc queries) | |||
Limiting Results in a Pivot Table | Excel Discussion (Misc queries) | |||
Pivot table colums selection | New Users to Excel | |||
pivot table selection | Excel Worksheet Functions |