Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 10 of 10

Thread: protect from being pirated

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Posts
    88
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I'm a novice to VB but I hope you can help me. I have written an Excel spreadsheet which I want to distribute to people .. but I want to restrict it from being copied or sent to 3rd parties. Is there a way of coding something in VB that can stop this ?

    I was thinking along the lines maybe of extracting some info from the registered users windows registry and incorporating this into their copy of the spreadsheet .. or password .. thus if that copy is run on another computer .. then it wouldnt load the spreadsheet.

    Any ideas .. or are there plug-ins that can do this sort of stuff.

    Thanks
    Bill

  2. #2
    MrExcel MVP Anne Troy's Avatar
    Join Date
    Feb 2002
    Location
    Westwood NJ
    Posts
    2,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Bill, always try search first, please. Thanks!

    http://www.mrexcel.com/board/viewtop...ic=358&forum=2
    ~Anne Troy

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Posts
    88
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    thanks .. it looks like I can password protect the VBA code from that link .. but what I was really looking for .. is a way to stop the spreadsheet from running if it has been illegally copied and is being attempted to run on another computer.

  4. #4
    Board Regular
    Join Date
    Mar 2002
    Location
    Arkansas
    Posts
    358
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I asked that question before myself. I was told that you could take some of the imformation that opperates your worksheet out and put it into a ( .dll ) file. But since I know nothing about programing dll's, Im back at square 1. Maby you could find a programer that could do this for you.

  5. #5
    New Member
    Join Date
    Feb 2002
    Location
    Benicia, CA
    Posts
    31
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    After I set the password and come back into VBA, I can still see the VB code and can still edit it. Is there something else i need to do to protect it? any help would be great. Thanks.

    Greg

  6. #6
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    You need to Save, close then re-open the Workbook for VBE protection to take effect.

  7. #7
    New Member
    Join Date
    Feb 2002
    Location
    Benicia, CA
    Posts
    31
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    thanks

  8. #8
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi
    Use a dll.
    xlVeryHidden all of your sheets.
    Lock your project.
    Call the dll to make your sheets visible.
    This will stop most people.
    They can copy your workbook but cannot see it.
    Can cutomize dll for each registered license.
    Will need VB, C++, ect to compile dll.
    Tom

    [ This Message was edited by: TsTom on 2002-03-25 00:57 ]

  9. #9
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi

    These posts are fine guys but help very little i have posted this question mant times and have done so for myself and others, but not one person has a usable answer, writting dll files in c++ or VB and needing that to even edit them is a bit far from usable to all bar a very few of us... the original poster dont care about protection, so dreamboats link hardly helps or answers the question. dave asvises hopw to opperate protection to kake effect and then we hear of writting dll files.

    Come n guys does anyone really know and does anyone have an example..

    I hjava question Dll are not all complied so why can we text edit them and save as dll??? will this not work as a reference, so the code need to be hidden agreed and call the file Jack.dll and that will check sub UK() equils Jack.dll in compleat form, not edits else fails... i beleive this is the idea, so the guy can have files that will not run on another PC....


    Well thats my take and what i get asked many times, like Java appel;et protection to programmers credits if your java script boys you understand..

    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  10. #10
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Small dll file for Jack to edit for me:

    MZd  @  !L!This program requires Microsoft Windows.
    $ NE<       @ P h c      P * L q
    L   4  0  RSRC16 WEP MYGETFREESYSTEMRESOURCES16
    DLLENTRYPOINT THK_THUNKDATA16   KERNELUSER? ?t ?^ ?X Resource Meter thunks ^ XZhu h h h RP thk_ThunkData32 U~
    tj 
      Uv  _ Uh@ h4 vfv = @  
          L   k  :   LS01   rsrc32.DLL rsrc16.DLL     4 VS_VERSION_INFO  
     
      ?    r StringFileInfo ^ 040904E4 &  CompanyName Microsoft Corporation 1  FileDescription Resource Meter 16-bit thunks 
    FileVersion 4.10.1998   InternalName RSRC16 < ( LegalCopyright Copyright (C) Microsoft Corp. 1994-1998 # OriginalFilename RSRC16.DLL 9 ) ProductName Microsoft(R) Windows(R) Operating System 
    ProductVersion 4.10.1998 $ VarFileInfo   Translation 


    Oops!

    Hee Hee

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •