Store hidden information in Excel throw Add-In

A

ARHangel

I want to create an VSTO Add-In and i want to store some information in excel
files that only the Add-In can access.

Is there a way?

Right now i store them on a sheet witch is not the ideal solution
 
J

Jon Peltier

You can't make it totally secure if you're using Excel, but you can make it
hard to access.

Sometimes I store data in a separate workbook, save the workbook as an
add-in, so the user cannot see it when it's first opened in Excel, password
protect the VB project so it cannot easily be converted to a regular
workbook (and made visible), and I'll use a different extension that isn't
associated with Excel so the user doesn't even think to open it in Excel.

I don't like storing information in a working add-in, since every change
means the file save time and date changes too, and it's harder then to check
versions.

- Jon
 
Top