Thread: How to protect my excel data (add-in or VBA)?)

I have a database ( actually a workbook) to send to my colleagues for some usage. But I hope to set some access or account control to protect my excel data from being copied.

Previously we implement the the access control modules in VBA ( like require passcode, check localhost's domain, check expiration date, forbid selecting and copying etc.) Since VBA project password is not so strong, one can crack and therefore change the VBA code. I hope to write the access control logic into add-in and therefore no one can change the code. But unfortunately, I found users can deny to install document-level excel customization(a kind of document-level add-in in my understanding),so the access control module in add-in won't work at all.

Is there any way that I can force excel to be opened only with customization(add-in) installed?

Or any advice on protecting my excel data?

Thanks a lot!!