I want to make available to several users at the same time a number of custom macros. It is important that I am able to make corrections (or additions / deletions) to these macros and they can not. Also it is important for the corrections to need be done only once as I do not want to go to 8 users & make repetitive corrections.
So i tried to make one hidden/shared workbook available to these users. Works, kinda, two problems 1] they could make changes to the macros & so it could contaminate all users and 2] even as a hidden workbook it askes to be saved evrytime someone closes excel. I tried to correct this by using "displays=false" but that effected all workbooks not just my test case.
Now I am thinking of trying an add-in.
I need help.
What I have done so far is this:
In the properties box of VBA I have changed the IsAddin from false to true. Then from within excel I have added the file as an add in. This opens well & closes without prompting. BUT I can not see the maros in that workbook when I enter {F8}. They are however visible when I enter {F11}.
I need to be able to attach those macros to either custom buttons or to objects in other workbooks (Depending on the user) so I need to be able to see them in the {F8} drop down box.
All help is welcome
So i tried to make one hidden/shared workbook available to these users. Works, kinda, two problems 1] they could make changes to the macros & so it could contaminate all users and 2] even as a hidden workbook it askes to be saved evrytime someone closes excel. I tried to correct this by using "displays=false" but that effected all workbooks not just my test case.
Now I am thinking of trying an add-in.
I need help.
What I have done so far is this:
In the properties box of VBA I have changed the IsAddin from false to true. Then from within excel I have added the file as an add in. This opens well & closes without prompting. BUT I can not see the maros in that workbook when I enter {F8}. They are however visible when I enter {F11}.
I need to be able to attach those macros to either custom buttons or to objects in other workbooks (Depending on the user) so I need to be able to see them in the {F8} drop down box.
All help is welcome