![]() |
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. |
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. |
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. |
All times are GMT +1. The time now is 11:58 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com