Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protect file on a shared Network drive
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Saving Excel File to a Network Drive | Excel Discussion (Misc queries) | |||
Shared Excel Files on Network Drive | New Users to Excel | |||
excel 2003 file converted to .xlsm file when save to network drive | Excel Discussion (Misc queries) | |||
Unable to overwrite file to network drive | Excel Discussion (Misc queries) | |||
Can't one excel file on network drive? | Excel Discussion (Misc queries) |