I have a workbook that consists of 13 worksheets. 1st worksheet is an
instructions page. the remaining 12 worksheets correspond to each month of a
calendar year. Each monthly worksheet is protected to prevent entry by users
in certain cells. whilst allowing them to complete the return by filling in
information in given cells.

At the end of the page is a combo box where they select either yes or no to
whether the worksheet is complete. This in turn refers back to the
instruction page updating that the particular worksheet is complete on the
instruction page.

What I am trying to do is a macro, that when the combo box is selected as
yes, automates to protect the entire worksheet regardless of whether a cell
is locked/unlocked, so that the information cannot be changed by the user
without the entering of a password.

Any ideas?
thanks