Password Protecting within a Macro

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?

Something wrong in your macro. Probably on an 'Exit Sub' or 'On Error Goto' you don't reactivate the protection.

Hi Rollis13

Thanks for responding. Any idea how I would correct this?

.
Post your workbook for review.

Do not include confidential data in the workbook.

Hi

The "Passivation Checklist" worksheet is the Input Worksheet, the "Passivation Database" worksheet is the Calculation Worksheet.

Sorry, no problem found in your macros.