Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Jan 2001
    Posts
    117
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Hiding Code (VBA 6)

    Can I strip the code from a VBA module and still have it function? The template contains code in a module and user forms as well. I would prefer that the code be hidden when I distribute it.

    - Linda

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Hiding Code (VBA 6)

    The module is just a container for the code, so no, it won't work if you strip the code out.

    If you want to protect the code in your modules and behind any userforms, you can do that from the VB editor. From the Tools menu there, select the project properties and you'll see a Protection tab. There's a checkbox on that tab that lets you protect the code so it can't be seen and you can enter a password so that you can still get into it when necessary. If you use it, though, be very sure you build in all the error handling you need first.
    Charlotte

  3. #3
    2 Star Lounger
    Join Date
    Jan 2001
    Posts
    117
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hiding Code (VBA 6)

    Exactly what I was looking for! Thank you very much!

    - Linda

Posting Permissions

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