| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Only allow certain users access to specific sheets within a workbo
You can hide the sheets, then password protect the workbook, protecting at
least the structure. Such protection is easily broken, but should keep all but the most determined users from subverting your efforts. -- Regards, Tom Ogilvy "Dixie" wrote in message ... I am trying to set a workbook up so that I can link to a specific sheet within a workbook and I do not want the users who use these links to be able to go to any of the other sheets. Is this possible? If so, how? We are currently using Excel 2002. Thanks! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Only allow certain users access to specific sheets within a wo
Hard to say, but if you have different divisions having a sheet in a single
workbook and you want to let them only see their own information, then I would say no, because there is only one password for the workbook. -- Regards, Tom Ogilvy "Dixie" wrote in message ... Will this work if different people need to access different sheets? Like, Each division (Their files are stored in a separate folder for each division) has a link to their specific sheet within the main workbook and we don't want them to access any other divisions sheets? Thank you! "Tom Ogilvy" wrote: You can hide the sheets, then password protect the workbook, protecting at least the structure. Such protection is easily broken, but should keep all but the most determined users from subverting your efforts. -- Regards, Tom Ogilvy "Dixie" wrote in message ... I am trying to set a workbook up so that I can link to a specific sheet within a workbook and I do not want the users who use these links to be able to go to any of the other sheets. Is this possible? If so, how? We are currently using Excel 2002. Thanks! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Only allow certain users access to specific sheets within a wo
Thank you much! That is what I thought too, but I was making sure. I am
trying to get the user to go to Access, but she doesn't want to. I don't know why people are afraid to use something that will make their lives easier! Thanks again! "Tom Ogilvy" wrote: Hard to say, but if you have different divisions having a sheet in a single workbook and you want to let them only see their own information, then I would say no, because there is only one password for the workbook. -- Regards, Tom Ogilvy "Dixie" wrote in message ... Will this work if different people need to access different sheets? Like, Each division (Their files are stored in a separate folder for each division) has a link to their specific sheet within the main workbook and we don't want them to access any other divisions sheets? Thank you! "Tom Ogilvy" wrote: You can hide the sheets, then password protect the workbook, protecting at least the structure. Such protection is easily broken, but should keep all but the most determined users from subverting your efforts. -- Regards, Tom Ogilvy "Dixie" wrote in message ... I am trying to set a workbook up so that I can link to a specific sheet within a workbook and I do not want the users who use these links to be able to go to any of the other sheets. Is this possible? If so, how? We are currently using Excel 2002. Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I track users who access a spreadsheet? | Excel Discussion (Misc queries) | |||
| Renaming sheets with the same name after copying into a new workbo | Excel Discussion (Misc queries) | |||
| How can I merge multiple sheets from different Excel files workbo. | Excel Worksheet Functions | |||
| Access with different users | Excel Worksheet Functions | |||
| users and DAO with access database | Excel Programming | |||
Linear Mode
