SCENARIO:
1. I have written some macros which simplify some repetitive tasks.
2. Other employees in the company would like to use the code for their personal project spreadsheets.
3. These other employees have zero knowledge of VBA
GOAL:
I want the employees to be able to go to a folder on the company drive and click an icon. This icon will then activate a text file macro which will run on their open spreadsheet.
That would be the ultimate solution however it may take to much time to program. If so does anyone have any other ideas to make running my code on other employees spreadsheets easier.
1. I have written some macros which simplify some repetitive tasks.
2. Other employees in the company would like to use the code for their personal project spreadsheets.
3. These other employees have zero knowledge of VBA
GOAL:
I want the employees to be able to go to a folder on the company drive and click an icon. This icon will then activate a text file macro which will run on their open spreadsheet.
That would be the ultimate solution however it may take to much time to program. If so does anyone have any other ideas to make running my code on other employees spreadsheets easier.
