I have a vba code that performs a few actions on a file that gets downloaded from a network weekly. The code is basically just to clean up the data and filter out uneccesary stuff. I want this macro to be available as an add-in on my workgroup's computers as well, so that we don't have to work from a template, but that the macro would work in any similar workbook as an add-in. The problem is, though, that we don't have administrative rights on our computers, so we cannot save it as an add-in. I am NOT looking for a way to bypass the admin rights, but I am just looking for the next best solution that could make this available on everyone's computers in this weekly file. It is possible to give the file the same name, e.g. Usage xxxx, with xxxx being the date or something like that.
I also need a way for them to run this with (maybe) a shortcut key, eg. ctrl + shift + m. Or a button, or something which will enable them to run the code without having to step into the code by pressing Alt F11...I don't really want anyone having access to the code, things might get messed up.
Any advice would be helpful, please?
Bookmarks