ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Help! Security when using a VBA macro to access an Excel File (https://www.excelbanter.com/excel-programming/364467-help-security-when-using-vba-macro-access-excel-file.html)

biker

Help! Security when using a VBA macro to access an Excel File
 
I have some data in an excel workbook and I wish to write some code to
extract one line (not so hard!). Where the problem arrives is I don't want
the user to see any of the other data in the worksheet (ever) - just that one
line that is extracted.

The macro (which would be converted to an add-in) would look like:
Load workbook
get one line of data
close workbook

But the user can hit <ctrl-break once the workbook is loaded and
see/examine the worksheet. What is the most secure method to use so that the
user cannot see the workbook? Would hiding the worksheets and protecting the
book work and macros work?

or alternatively would it be better to put the data into a database or csv
file?

Security is the paramount concern

Any Help Appreciated

Regards,




All times are GMT +1. The time now is 11:29 AM.

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