Information générale
Catégorie:
COM/DCOM et OLE Automation
Versions des environnements
>> 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.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement