I have a problem I hope someone can help.

I have a workbook with a VBA project, both of which are password protected.
I want to progmatically save the changes to the workbook.

I can unprotect, change necessary cells, and then reprotect the workbook.
However I get an error message saying that the file cannot be saved when the
VBA project is protected. I cannot find any information as to how to
unprotect the VBA during saving and then reprotect.

Or am I going about this the wrong way.