Ways to securely store API key in Excel VBA

[PrashanthKumar123]

I have a VBA program that processes user's input data.I am planning to distribute this tool to users in the coming days. The program also has an API connection to an external database. This uses a static Api key that I've currently embedded into the VBA code.

Given the possibility to crack password in Excel I am looking at ways secure my API key so my database is not exposed.

Any recommendations to securely store or encrypt API key in VBA?

Thanks

 

[JEC]

Secure your VBA project as well, that is the only security available in Excel