Results 1 to 2 of 2

Thread: Can I use VBA to Lock VBA where Password already exists?
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Jan 2005
    Posts
    261
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Can I use VBA to Lock VBA where Password already exists?

    I made a careless mistake and left the 'Lock project for viewing' box unchecked and sent out copies of one of my models. A project password already exists. I had just unchecked the 'Lock' box for my convenience while I did some annual updates, but then forgot to check it again before sending out the updated model.

    I do have regularly scheduled VBA-driven updates. Is there any way I can use the update to re-lock the code on the base model?

  2. #2
    Board Regular Artik's Avatar
    Join Date
    Jun 2012
    Location
    Poland
    Posts
    93
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Can I use VBA to Lock VBA where Password already exists?

    To change something in a VBA project on a given computer the "Trust access to object model of VBA project" option must be selected. By default, this option is not enabled. Without this "trust" all your effort will be in vain. When upgrading the version, go towards replacing the entire file, not its code.

    Artik

Some videos you may like

User Tag List

Tags for this Thread

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
  •