CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 4 of 4
  1. July 8th, 2003, 11:44 PM #1
    ekta_singh
    ekta_singh is offline Member
    Join Date
    Apr 2002
    Location
    Mumbai, India
    Posts
    106

    Protecting a VBA project

    Hello Gurus,
    I have written a macro in Excel.I want to protect this code.Is there any way I can do this?When I give my project to the user,he should only be able to access the worksheet and not be able to see the code at all.Please help.

    Thanks & Regards.
    -Ekta
    Reply With Quote Reply With Quote
  2. July 9th, 2003, 05:57 AM #2
    ekta_singh
    ekta_singh is offline Member
    Join Date
    Apr 2002
    Location
    Mumbai, India
    Posts
    106

    Angry

    Doesn't anyone have any idea at all?Please help or please suggest some other site where I might be able to find help.
    -Ekta
    Reply With Quote Reply With Quote
  3. July 9th, 2003, 07:20 AM #3
    Cubbie
    Cubbie is offline Member
    Join Date
    Feb 2001
    Location
    PA
    Posts
    163
    in the Visual Basic editor select Tools, VBA Project Properties..., then the Protection tab.
    Reply With Quote Reply With Quote
  4. July 10th, 2003, 12:12 AM #4
    ekta_singh
    ekta_singh is offline Member
    Join Date
    Apr 2002
    Location
    Mumbai, India
    Posts
    106

    Thanks...

    Thanks a lot Cubbie.
    -Ekta
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules




Click Here to Expand Forum to Full Width

Featured