Saving Workbook having Macros

[Niaz]

My workbook have some module level macros. It has also code attached to Controls on Worksheet. I tried to protect the workbook with password. Now I can not save this. Is there any way, I can save this workbook while hiding the macros and codes.

Thanks in advance

[jasoncw]

Yes, there is no need to protect the workbook. Instead, you need to protect the VBA project. Enter the VBE, right-click on the project in the project explorer, and select properties. On the protection tab, select locked, and assign a password.

HTH

Jason

[Niaz]

Thanks jason

I actually protected the VBA Project. I did not protect the workbook. But I don't know why I can't save the project.

Niaz