In an MS Excel VBA program I am facing a problem. I am unable to save data in my spreadsheet when the VBA project is locked with a password (In the VBA project properties). When I give the VBA project password for the first time then I am able to save data on my sheets. But when the next time I open the workbook and try to save data in the sheet , it gives me the error message staing that I cannot save the file until the lock and password from the VBA code is removed.

It is only when I remove the VBA project password that I am able to save data. Because of this I am not able to give adequate protection to my spreadsheet data and the VBA code in the Excel file. It appears quite ridiculous that one cannot save his spreadsheet just because he has protected his VBA code with a password and ticked the lock option in VBA project properties.

Another thing I want to know is how can I disenable the “disable macro, run macro’ message which comes when the workbook is opened. I want my users not to work in the “disable macro” mode.


I would be grateful if anyone could help me with this.

Regards
Manish
my email id is [email protected]