Lock VBA code from Viewing

[hernandj]

I am trying to lock my VBA code from viewing and changing. I also have an autosave routine that saves the workbook after the user exits. Apparently, they conflict with each other because If I lock the code, the autosave does not work. I get an error message saying that the file can not be saved.

Is there any other way to lock the VBA Code?

Thanks in advance for your consideration.

 

[venkat1926]

what about this url

http://www.ozgrid.com/VBA/protect-vba-code.htm

 

[hernandj]

Thanks for the response. That is the procedure I used and it works. The problem is that it conflicts with a autosave routine that is part of the VBA. When the autosave procedure runs, it can not save the backup copy. The autosave saves a copy of the workbook for the user in a folder called ExcelBackup. This is in addition to the original workbook.

I was hoping that there would be a way for me to accomplish both missions.

Thanks again for the effort