Hi Guys
I have created a tool that I wanted to save as an add-in, however I'm not sure if it is possible. Whilst I have created Add-ins before, this one is different as it includes a number of worksheets that are either used as templates to be copied into another workbook, or used for storing information.
This is a one button tool that unhides the worksheets when the macros are running, and then hides them when the macro is finished.
So my question is, what is the best way to set this tool up (so that it can be sent to collegues for use). Can you actually save it as an add-in with the worksheets being used? Or am I better off treating it as an excel workbook and writing an auto_open & auto_close macro in everyone's Personal workbook?
All thoughts are appreciated.
I have created a tool that I wanted to save as an add-in, however I'm not sure if it is possible. Whilst I have created Add-ins before, this one is different as it includes a number of worksheets that are either used as templates to be copied into another workbook, or used for storing information.
This is a one button tool that unhides the worksheets when the macros are running, and then hides them when the macro is finished.
So my question is, what is the best way to set this tool up (so that it can be sent to collegues for use). Can you actually save it as an add-in with the worksheets being used? Or am I better off treating it as an excel workbook and writing an auto_open & auto_close macro in everyone's Personal workbook?
All thoughts are appreciated.