ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How do I unprotect the saturdays on the atendance calendar (https://www.excelbanter.com/excel-programming/369243-how-do-i-unprotect-saturdays-atendance-calendar.html)

Joan McGahee

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.


Charlie

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.


Joan McGahee[_2_]

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