Hi

I have created a workbook and password protected all my sheets, except for Specific Cells within Input Worksheets. Information input into these unprotected cells feed into other Calculation Worksheets and calculations are done there.

I then recorded a Macro in order to save the information that was input into the Specific Cells within Input Worksheets. When recording the Macro I need to unprotect the relevant Calculation Worksheets, carry out a few commands and then Password Protect the sheet again and Stop the recording of the Macro.

Every time I run the Macro for the first time after Password Protecting the sheet, MS Excel asks for the Password. After that, the Macro does not ask for the Password again and the functionality works fine, however on odd occasions, the Macro leaves the Calculation Worksheet unprotected.

Is there anyway of ensuring that this does not happen?