I have six worksheets in one workbook the first worksheet (Appointments) is used as the primary input sheet and the remaining sheets get updated automatically with the following code
I wish to protect some fields on the five remaining worksheets from being over typed and thus have applied protection - however as these sheets are protected I am unable to edit the first worksheet. Can I modify the code above to allow update of protected cells or happy to consider another approach.Please Login or Register to view this content.
Thanks Tony
Bookmarks