Hi All,
I'm working on a workbook, with confidential data, where I need to put restrictions on who can use it.
Normally I will just put on a password to open the workbook, but that won't do it here.
E.g. an employee will always be able to use the workbook, even though he is no longer at the company.
Therefore I was wondering, is there a more secure way/what is the "normal" thing to do, to secure your data from unauthorized use?
I was thinking a solution could be:
When opening the workbook, the user will be prompted a userform, where they enter their initials. Excel will then generate a password and send this to the users email-address (user and email will be stored in the sheet I think).
The user will then have to put in this password, before sheets are being unhided and the workbook can be used (maybe there should also be an administrator password).
Is this possible or should I go another way?
/Skovgaard
I'm working on a workbook, with confidential data, where I need to put restrictions on who can use it.
Normally I will just put on a password to open the workbook, but that won't do it here.
E.g. an employee will always be able to use the workbook, even though he is no longer at the company.
Therefore I was wondering, is there a more secure way/what is the "normal" thing to do, to secure your data from unauthorized use?
I was thinking a solution could be:
When opening the workbook, the user will be prompted a userform, where they enter their initials. Excel will then generate a password and send this to the users email-address (user and email will be stored in the sheet I think).
The user will then have to put in this password, before sheets are being unhided and the workbook can be used (maybe there should also be an administrator password).
Is this possible or should I go another way?
/Skovgaard