+ Reply to Thread
Results 1 to 2 of 2

VBAProject protection code

  1. #1
    Forum Contributor
    Join Date
    04-23-2007
    Location
    Texas
    Posts
    417

    VBAProject protection code

    I've done some searching and I'm lost. What I would like to do is unlock and lock the Project. Problem I'm having is when I lock the project I can't run other macros. I open the sheet and press a button and get the error that the project is locked. How can I Unlock the project and then lock it after the other modules run?

    I've locked the workbook and when the button is pressed to run the macro's, I unlock the workbook protection and then lock the workbook when finished. Can this be done in the same way for the VBAProject?
    Last edited by Tortus; 01-27-2015 at 01:44 PM.
    If we all use our Minds our Heads and our Brains NO TELLING what we could come up with!!

  2. #2
    Forum Contributor
    Join Date
    04-23-2007
    Location
    Texas
    Posts
    417

    Re: VBAProject protection code

    I hate when I post questions and figure it out on my own. Wastes everyone's time. I figured out I'm locking the project at the top level and this was causing the problem. If I lock 1 module in the project it does what I would expect.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How to save code under VBAProject(PERSONAL.XLSB) that applies to any workbook
    By bubai in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-28-2013, 08:01 AM
  2. [SOLVED] Protect VBAProject from within the code
    By Ken Soenen in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-13-2006, 07:00 PM
  3. Protection - restrict macro exposure to the workbook, VBAProject
    By JB2005 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-15-2005, 09:45 AM
  4. Activate code from another VBAProject
    By MVM in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-05-2005, 03:10 PM
  5. Activate code from another VBAProject
    By MVM in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-02-2005, 06:17 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1