I have an excel macro created . I would like to share that with my team mates but the company is worried that if employees move on that could be shared with a competitor.
There are two options in my opinion- one is that the macro is converted to an exe file which is time limited . The second one is that a web page is created for access to the macro based on a simple authentication mecahnism.
The macro has 9 tabs in total . One is an input tab, where the file location is provided and the parameters are given. 4 are output tabs -these include mainly tables of the processed data and also charts which are drawn. The other 4 are hidden processing tabs.
Also since the macro keeps getting updated frequently, I would need to know how this will be done with necessary software too.