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

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...