Results 1 to 2 of 2

Thread: Hide VBA Code *RESOLVED*

  1. Aug 19th, 2003, 07:06 AM #1
    pavan
    pavan is offline

    Thread Starter
    Addicted Member
    Join Date
    Mar 2001
    Location
    India
    Posts
    134

    Hide VBA Code *RESOLVED*

    Hi to all

    I've created an excel sheet which after entering of data and press of a button will save the data to a database. I've accomplished this using VBA.

    This is working fine. But now, I want to hide my VBA code, so that the people entering data should not be changing any part of the code but some authorised people should be able to.

    I'm new to VBA and I dont know how to do this?

    Pls. Help
    Last edited by pavan; Sep 5th, 2003 at 08:02 AM.
    Pavan Kumar
    Reply With Quote Reply With Quote
  2. Aug 19th, 2003, 07:29 AM #2
    alex_read
    alex_read is offline
    Evil Genius alex_read's Avatar
    Join Date
    May 2000
    Location
    Espoo, Finland
    Posts
    5,538
    Open your excel file up & go into the vba editor window. Under the tools menu, you'll see a submenu entitled "VBAProject Properties" - by setting the options on the second tab of this screen, you can password protect the code so no-one can see or edit this without first knowing the password...

    Please rate this post if it was useful for you!
    Please try to search before creating a new post,
    Please format code using [ code ][ /code ], and
    Post sample code, error details & problem details
    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