How to automatically run add-in when workbook opens

I have this Add-In code below that works for me fine when I run it under macro's but how can I get this to run every time this excel file is open? this will be a shared file and most people don't even know how to get to macro's to run them let alone what they are. So I would like to have this Menu Command run when a user opens it so it will always be there. I have copied this from a place before and it works but I just can't get it to run automatically when the workbook opens.

Please Login or Register  to view this content.

If you want this to run whenever a workbook opens then you need to save your macro to a standard module in that workbook, and in the "ThisWorkbook" module put something like the below which would call your macro when the workbook opens:

Please Login or Register  to view this content.