How can I saet up multiple users with access to select Macro Modules

[Siggy19]

I have a number of users who need Macros installed in Excel on their machines.

Currently, we add the relevent macros to their individual xlstart directories.

However, this becomes an administrative nightmare since when a particular macro is changed, it needs to be manually re-installed on each user's machine.

What I would like to do is to have a 'library' of macros in a directory on the network and then to be set up each user to have access to only those macros that they need.

This would allow me to change the macros more easily, but would prevent User A having access to a macro that they should not use.

Any ideas on how this can be done ?

 

[Dreamboat]

Create an Alternate Startup directory.
Place the file there.

You could have diff startup dirs, like Level1, Level2, etc.

Excel VBA Certification is Finally Here!

http://www.vbaexpress.com/forum

 

[Siggy19]

The problem with that solution is that I would need to be able to assign multiple alternate startup directories for a single user or would need multiple copies of some of the macro modules... and I hate having multiple copies because I always forget to update one of them !

One option I am thinking of is... can macros be loaded dynamically ?

In other words, could I have a macro on every machine that looks at a user list and only loads the macros assigned to that user ?

 

[Dreamboat]

In an effort to get there quicker...

Presumably, given the following macro, then you could do what you want, too?

http://www.vbaexpress.com/kb/getarticle.php?kb_id=33

Excel VBA Certification is Finally Here!

http://www.vbaexpress.com/forum