add-ins & security

[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

 

[Tom Ogilvy]

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.