Dynamic Passwords
I have a pivot table categorized by person. I would like each person to be
able to view the backup data by double-clicking their name, but not be able to let anyone else view the info. Is there any way I can have excel prompt the user to enter a unique pre-defined password such that they may only view their own backup data? |
Dynamic Passwords
In article , ?B?U2luZ2g=?= wrote:
I have a pivot table categorized by person. I would like each person to be able to view the backup data by double-clicking their name, but not be able to let anyone else view the info. Is there any way I can have excel prompt the user to enter a unique pre-defined password such that they may only view their own backup data? Excel's password protection is fairly lax, so the basic answer here is probably no. If someone cares enough, they could remove the passwords. No idea how you might protect polite people against each other though, sorry. :) |
All times are GMT +1. The time now is 12:58 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com