Lock VBE or Lock Macro

Hi Frds,

I have problem in locking the VBE. I had a VBA code and is running perfectly Okay. I tried to lock it before sending it to client. I tried to Lock from tools>VBA ProjectProperties> Protection , there i ticked on check box and given the password.

I saved and reopened the sheet. The Problem has come here. The movement i reopened , VBA is not function to which i coded and when i when in VBE window , the entire code got erased ..!!

Please help me, how to lock the code from users to view.

Million Thanks ,
Sri

Hi Richard,

I am saving on local desktop only.

The problem got resolved !! , I was saving the protected file in xlsx format . when i did saved the file with xltm extension, it is working fine.

Thanks,
Sri