Results 1 to 2 of 2

Thread: Best way to secure VBA

  1. #1

    Thread Starter
    New Member
    Join Date
    Jun 2006
    Location
    Irvine, CA
    Posts
    5

    Best way to secure VBA

    I am working with an application that has some VBA projects embedded (not excell, actually and industrial HumanMachineInterface program). Any the manufacturer has some VBA projects embedded into it that are protected by being "hidden". I see the title but when I try to expand the project I get a msgbox saing "project is unviewable" with a titlebar reading "Project locked". Right clicking does not even give me the option to unhide it or enter a password to unlock or view.

    Question 1. Has anyone seen this before? it seems way better than password protecting the VBA project and I would love to do this to my projects in this application

    Question 2. Has anyone done this before? And if so can you tell me how?

    Thanks in advance!
    Randy

  2. #2
    Ex-Super Mod RobDog888's Avatar
    Join Date
    Apr 2001
    Location
    LA, Calif. Raiders #1 AKA:Gangsta Yoda™
    Posts
    60,709

    Re: Best way to secure VBA

    It project protection. Under the VBA IDE you would click - Tools > Project Properties > Protection tab > check the box for "Lock project for viewing" > then enter in a password and enter in confirm password > click OK. Close your instance of your app, reopen, press Alt+F11 to open the VBA IDE, click on the project node to expand and view and you will get the same protection.

    Then to view it enter in the password in the popup dialog box and it will open.

    What app are you using?
    VB/Office Guru™ (AKA: Gangsta Yoda®)
    I dont answer coding questions via PM. Please post a thread in the appropriate forum.

    Microsoft MVP 2006-2011
    Office Development FAQ (C#, VB.NET, VB 6, VBA)
    Senior Jedi Software Engineer MCP (VB 6 & .NET), BSEE, CET
    If a post has helped you then Please Rate it!
    Reps & Rating PostsVS.NET on Vista Multiple .NET Framework Versions Office Primary Interop AssembliesVB/Office Guru™ Word SpellChecker™.NETVB/Office Guru™ Word SpellChecker™ VB6VB.NET Attributes Ex.Outlook Global Address ListAPI Viewer utility.NET API Viewer Utility
    System: Intel i7 6850K, Geforce GTX1060, Samsung M.2 1 TB & SATA 500 GB, 32 GBs DDR4 3300 Quad Channel RAM, 2 Viewsonic 24" LCDs, Windows 10, Office 2016, VS 2019, VB6 SP6

Posting Permissions

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



Click Here to Expand Forum to Full Width