I have an AddIn file with a macro to batch open any selected cells in an open Excel workbook containing weblinks. I want to be able to share this AddIn file without users needing to install the addin and just have the code run upon opening the file, but cannot seem to get it to work.
I've tried doing Sub Workbook_Open() under This Worksheet and Sub Aut
pen() in a module and neither one works.
If I run the code manually from the VBA editor, it works perfectly fine but it doesn't execute the macro when the file is opened that way I want.
I've tried doing Sub Workbook_Open() under This Worksheet and Sub Aut
pen() in a module and neither one works. If I run the code manually from the VBA editor, it works perfectly fine but it doesn't execute the macro when the file is opened that way I want.
