Just am trying to figure out how to have people install macros automatically? My first thought is since macros are VB, can I write a macro to install other macros easily?

I have a couple of (possibly-not-so) unique factors:

1) Users do not have administrative rights to thier computers since we upgraded to Win 7.

2) I do keep a central macro repository in our EPDM vault, with read access for non-administrative users.