Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I unprotect the saturdays on the atendance calendar
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I unprotect the saturdays on the atendance calendar
Thanks
"Charlie" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
No. of Saturdays between 2 dates | Excel Worksheet Functions | |||
Difference - except for Saturdays and Sundays | Excel Worksheet Functions | |||
Need a way to determine the # of Saturdays in a month | Excel Worksheet Functions | |||
Count # of Saturdays in a month | Excel Discussion (Misc queries) | |||
Skipping Saturdays and Sunday | Charts and Charting in Excel |