I place a file on a network drive which is available to all
users.

I tell the users to copy the file to their own drive (either
network or local) and open the copy there. If they do so,
then code in the ThisWorkbook module will complete the
process.

By placing the file centrally on the common network
drive, I figure that updates will be easier to manage,
but, two questions please:

1. Can I detect the file being opened from its's
original location, and stop code executing,
prompting user to first copy the file.
2. Can I stop user from modifying the file's
properties (eg name) because that might
cause me a few problems!

I'm trying to introduce new users to a few little macros.
Longer term, when they're more comfortable, it will be
far better distributed as an addin, but until then.......?

Distributed under Excel 2003 and XP Pro.

Regards.



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.719 / Virus Database: 475 - Release Date: 12/07/2004