add-ins & security

  • Thread starter Thread starter Eric
  • Start date Start date
E

Eric

I reading 'Writing Excel macros with VBA', where the author (Steve Roman)
advocates making projects as add-ins. He doesn't say whether doing so gets
around making the code trusted or not from a security standpoint.

Anyone know? Anyone agree/disagree about using add-ins as a preferred
methodology in general?

TIA
 
Addins are not any more secure than workbooks, but offer other advantages.
If they are trusted by the user, then they don't raise macro warnings. The
user doesn't enter data in them, so correcting your code and redistributing
an updated addin will be easier.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Add-ins not loading 3
VBA code won't run, even with Macro Security set to Enable All Macors 9
Programmatically check security of VB Project 3
Secure Add-ins 2
Cannot display Add-in Macro list without going to VBA/Project 5
Workbook_SheetSelectionChange problem in my add in 3
Add-in WITH worksheets?? 1

Back
Top