I have created an Excel Workbook, made up of numerous Worksheets. These
worksheets are used to record daily information, at various locations, for
bi-weekly periods. One cell, €˜J3 is used to establish the beginning date of
the period. The first date of the period is automatically entered in €˜C12,
by using €˜=J3. The next date of the period is automatically entered in cell
€˜C13 by using =IF($J$3="","",$J$3+1), the next date is auto entered in €˜C14
using =IF($J$3="","",$J$3+2), and so on. Portions of the protected worksheet
are locked, when used in entering the information.

Would it be possible to create a new bi-weekly series of worksheets by
entering the beginning date in €˜J3 on one page? Also is it possible to
€˜Unprotect and Protect all worksheets by a single operation? It is
cumbersome to have to unprotect each worksheet, change the value in J3 on
each worksheet and then protect each worksheet again. Have you any
suggestions?