Lock Down Spreadsheet to Specific Users

[Falko26]

Hey Team,

Curious questions here. My company has just finished developing an Excel Spreadsheet full of VBA code and functions that we wanted to protect.
Is there a way that we can lock down our spreadsheet from an access perspective. Like you have to have some credentials to be able to sign into it? We really would like it to work as a licensing system where if you leave the company we can remove the license from that employees email which would stop them from accessing the document.

Does anyone have any ideas on achieving this goal?

 

[Candyman8019]

To find your domain name, you can create a sub with the following:

msgbox CreateObject("WScript.Network").UserDomain

 

[Candyman8019]

or

msgbox environ("userdomain")

 

[Candyman8019]

I just noticed this morning that I left a fake domain in the code and rendered the sheet useless...I just commented out that bit so it can be opened now.