Allow VBA on Domain?

[Lydon Bergin]

I have developed a VBA Application in Excel that I want to push out to a few
of my users. They are all on a domain and I was wondering if there were
some way that I could either change the domain policy or change the security
settings on the Workbook so that they would simply be able to open it and
use it?

 

[Dave]

short answer... yes.

long answer, how you do it depends on what you want them to be able to do.
do you want them to share a single instance of the file so they all share
the same data? or do you want each user to have their own copy?? it also
depends on what you have for network resources and security settings. in
some cases you could just share a folder on your machine and let them either
share it or copy it from there, this isn't always the best thing though
since it depends on your machine being available and lets them have access
to at least some of it. the better way is usually to have a shared network
drive on a server that you can all read and write to, then just put the file
on there and tell the users how to copy or open it... also, beware of
trying to have more than one user at a time open an excel file, that's
usually not a good thing to do.