General information
Category:
COM/DCOM and OLE Automation
>> Why do not you trust security in Excel?
>Because anyone can bypass; create a copy of the file, go in VBA code using ALT-F11, etc. We need ONE master just to enter data and print.
>
>> Anyway, I would show the Excel data as a view and in the grid on the form.
>Not really good, because the Excel file contains a lot of spreadsheets with complex macros. It's not only data.
In the past I made several attempts to make something like read-only Excel file, or hide Excel Menu, protect cells/sheets/workbook, etc. And I was not able to get exactly or all what I needed, basically because of tons of hot-keys that need to be disabled, and it was not clear how. Not to mention that many Excel features, if disabled, need to be enabled back in the code: user cannot enable them back.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only