Protect file on a shared Network drive

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Stuart (sg_booth_at_hotmail.com)
Date: 07/15/04 

Date: Thu, 15 Jul 2004 15:25:07 +0100

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

Relevant Pages

  • Re: Macros in Word 2003 with SP2
    ... Put them on a network drive. ... AutoText, AutoCorrect, keyboard assignments, toolbars, macros, etc. ... I copy them into each user's Word startup folder? ... I can go into Tools, Templates and Add-Ins, Global ...
    (microsoft.public.word.vba.customization)
  • Re: Using exact-size structs to go thru raw byte buffers
    ... struct FrameHeader { ... The alignment of "proto" ... to convert to and from platform and network byte order. ... If network and platform correspond the macros do nothing. ...
    (comp.lang.c)
  • Re: Distributing Macros/Templates to a large Organization
    ... macros if they're asked, and/or makesure their Word macro security is set to ... this would come down to get to know the network (Active Directory) ... control buttons that hide/unhide parts of the doc. ...
    (microsoft.public.word.vba.beginners)
  • Re: Message Box About Macros When Open Word
    ... network and if I change the default font, it should be default for ME ... the changes in the global template. ... The "The function you are attempting to run contains macros or content ... Now the "save to global template" prompt shows up. ...
    (microsoft.public.word.application.errors)
  • Re: macro file
    ... You place a common global template on a network disk. ... >> AutoText, AutoCorrect, keyboard assignments, toolbars, macros, etc. ...
    (microsoft.public.word.vba.general)