| 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 | |||
Hybrid Mode
