+ Reply to Thread
Results 1 to 2 of 2

Macro to get to VBA Project Password

Hybrid View

  1. #1
    Steven
    Guest

    Macro to get to VBA Project Password

    I recently learned that you cannot programmatically change the VBA Project
    Password. I like to password the VBA Editor so when I make a change to the
    code I have to go the long way around to input the password. I was wondering
    if there is a code that will at least open the box to input the password. It
    is such a pain to Click Tools / Macro / VB Editor ... then Tools / VBA
    Project Properties.

    Thanks for your help.

    Steven

  2. #2
    Gary L Brown
    Guest

    RE: Macro to get to VBA Project Password

    Sub TestMe()
    Application.SendKeys ("%{F11}")
    Application.SendKeys ("%te")
    End Sub

    HTH,
    --
    Gary Brown
    gary_brown@ge_NOSPAM.com
    If this post was helpful, please click the ''Yes'' button next to ''Was this
    Post Helpfull to you?''.


    "Steven" wrote:

    > I recently learned that you cannot programmatically change the VBA Project
    > Password. I like to password the VBA Editor so when I make a change to the
    > code I have to go the long way around to input the password. I was wondering
    > if there is a code that will at least open the box to input the password. It
    > is such a pain to Click Tools / Macro / VB Editor ... then Tools / VBA
    > Project Properties.
    >
    > Thanks for your help.
    >
    > Steven


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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