Check User
Hi,
I hope someone could help me. I broadcast an Excel file with confidential financials which I have codes to control who to view which sheets through asking respective users to enter their passwords. However this is still not good enough. I want to identify user machines so users cannot share passwords. Could someone help me how I could achieve this? Rgds, |
Check User
This will give you name of the computer:
environ("computername") You should remember that Excel security is, at best, a minor inconvenience for anyone with a minute and a little curiosity. If a user really should not see the others' information, don't include it in the file. Otherwise, expect that sooner or later, one of your users will have the inclination to snoop. NickHK "KC VBA Qns" wrote in message oups.com... Hi, I hope someone could help me. I broadcast an Excel file with confidential financials which I have codes to control who to view which sheets through asking respective users to enter their passwords. However this is still not good enough. I want to identify user machines so users cannot share passwords. Could someone help me how I could achieve this? Rgds, |
Check User
Thanks, Nick.
I completely understand on the security aspect. Now what must the user do to retrieve their computer names and forward to me for embedding into my codes? Rgds, |
Check User
You can user that in your code:
Dim CompName as string CompName=Environ("computername") NickHK "KC VBA Qns" wrote in message oups.com... Thanks, Nick. I completely understand on the security aspect. Now what must the user do to retrieve their computer names and forward to me for embedding into my codes? Rgds, |
All times are GMT +1. The time now is 10:28 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com