You should never distribute a workbook that has secure information in
it and hope that the recipient will not discover that information.

You need to research how to use Excel Addins.

Store all information, including the secure information, into an Addin
Worksheet that resides only on your machine.

Use VBA to copy the non-secure information to a separate distributable
worksheet.