c# - Force an Excel file to be associated with a VSTO addin -
this use case: need develop excel vsto add-in prevents user accessing excel file unless add-in installed. add-in authenticates current user, , if successful, grant them access file. need way protect file uses own authentication (and not built-in password protection provided microsoft. why? because need able revoke access file , local password prevent me doing so)
i know how write add-in, don't know is, how force file associated plugin? tried using custom property, hack-able. basically, have custom property says: "use add-in", knowledgeable user go in advanced properties , delete it.
my suggestion use com add-ins, not distribute code user , can't hacked. simple add-in, uses .xla or .xlam files password protected vba projects can hacked.
now, workbook, suggest encrypt , scramble data , use com add-in decrypt data , use function prevent saving workbook un-encrypted. override workbook_onsave method encrypt on saving. disable copying of cell values.
for part, don't know if possible, need override user access vba editor, couldn't walk around add-in protections , disable access options menu disable add-in. can achieved overwriting excels shortcut keys , hiding menu bar.
again, last part, don't know if it's possible limit user access vba editor. think pretty similar limiting access add-in controls overriding alt+f11 shortcut , hiding developers tab whole.
well that's 2 cents, luck!
Comments
Post a Comment