View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Charlie Charlie is offline
external usenet poster
 
Posts: 703
Default How do I unprotect the saturdays on the atendance calendar

First unprotect the sheet.

Tools -- Protection -- Unprotect Sheet

Then select the cells for Saturdays and Sundays (all at once or one at a
time) and unlock them.

Format -- Cells -- Protection -- (uncheck the "Locked" checkbox)

Last, reprotect the sheet.

Tools -- Protection -- Protect Sheet


"Joan McGahee" wrote:

How can I unprotect the saturday and sunday cells on the attendance calender.
I need the because my daughter had to go to school on some saturdays and
sundays to get in her 180 days.