Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.
Forums » Excel Forums » General » macro protection

macro protection

Previous | Next
Latest post Thu, May 1 2008 3:59 AM by hrlngrv. 5 replies.

  • Wed, Apr 30 2008 4:24 PM

    • Tonysexcel
    • Top 75 Contributor
    • Joined on Tue, Feb 12 2008
    • Posts 6
    • Points 126

    macro protection

    Reply |Contact

     I want to secure macros from being edited, viewed or deleted by users. Does anyone know how to do this?
    Filed under:
    • Post Points: 21

  • Wed, Apr 30 2008 4:32 PM In reply to

    Re: macro protection

    Reply |Contact |Mark as Answer

    Hi

     

    From within the VBE go Tools>VBA Project Properties>Protection tab  and check "Lock Project For Viewing" and apply a password.

     

    Richard

     
    • Post Points: 37

  • Wed, Apr 30 2008 4:51 PM In reply to

    • Tonysexcel
    • Top 75 Contributor
    • Joined on Tue, Feb 12 2008
    • Posts 6
    • Points 126

    Re: macro protection

    Reply |Contact |Mark as Answer

     Sorry, but for some reason I stumble into it with the new version of Office 2007 and can't find how to get there consistently...
    • Post Points: 21

  • Wed, Apr 30 2008 4:54 PM In reply to

    Re: macro protection

    Reply |Contact |Mark as Answer

    Hi Tony

    You need to click on the workbook that contains the macros in the top left Project window within the Visual Basic Editor and then go through the steps I gave above.  You should be able to reliably get to the required screen.

     

    Richard

     
    • Post Points: 21

  • Wed, Apr 30 2008 5:13 PM In reply to

    • Tonysexcel
    • Top 75 Contributor
    • Joined on Tue, Feb 12 2008
    • Posts 6
    • Points 126

    Re: macro protection

    Reply |Contact |Mark as Answer

     THANKS!
    • Post Points: 5

  • Thu, May 1 2008 3:59 AM In reply to

    • hrlngrv
    • Top 10 Contributor
    • Joined on Thu, Jan 17 2008
    • somewhere in the western US
    • Posts 67
    • Points 1,055

    Re: macro protection

    Reply |Contact |Mark as Answer

    RichardSchollar:
    From within the VBE go Tools>VBA Project Properties>Protection tab  and check "Lock Project For Viewing" and apply a password.

    Caveat: even VBA Project password protection is fairly simple to defeat.

    http://www.schmittis-page.de/excel/vba/t48e.htm

     

     
    • Post Points: 5
Page 1 of 1 (6 items) | RSS
Copyright Excel User Group and the relevant contributors, 2008. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.