ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Store hidden information in Excel throw Add-In (https://www.excelbanter.com/excel-discussion-misc-queries/173564-store-hidden-information-excel-throw-add.html)

ARHangel

Store hidden information in Excel throw Add-In
 
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

Jon Peltier

Store hidden information in Excel throw Add-In
 
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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"ARHangel" wrote in message
...
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





All times are GMT +1. The time now is 01:49 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com