Avoid unauthorized copies of the Excel file

Posted on 2012-08-29
Last Modified: 2012-09-07
I need some advice on how to do this...

I have an Excel file that has some macros. This file is distributed to a number of employees to use on their daily work.
I want to prevent that this file can be used outside the company, either if the employee sends this to a friend or the employee leaves the company and goes to work on another company.
What is the best way to prevent this?

Thanks for your input on this one...


Question by:jppinto
    LVL 95

    Accepted Solution

    Get a Digital Rights Management (DRM) product.  Here's one:

    And there's a Microsoft solution... start here:
    LVL 16

    Assisted Solution

    An easy way would be to protect your macros by creating a DLL to be used as an add on in the local instances of Excel - and not be inherent within the file, so that even if the file gets used outside the office, there would be no macros to run on the new machines.
    Step by step instructions here:

    You can also find some info here:

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    This article will show you how to use shortcut menus in the Access run-time environment.
    Recently Microsoft released a brand new function called CONCAT. It's supposed to replace its predecessor CONCATENATE. But how does it work? And what's new? In this article, we take a closer look at all of this - we even included an exercise file for…
    The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …
    This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

    732 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    24 Experts available now in Live!

    Get 1:1 Help Now