Hello Friends,
The attachment here has an attendace sheet.
The boxes in yellow are Thursdays & Fridays.
I want a macro that would:
1. Protect all the cells in yellow.
2. The macro will take effect in all the existing cells.
I could have recoded a macro for all the sheets, but in 2007 the yellow cells will be in different columns. That is why I need a macro that would look for yellow cells and prtoects it from any entry.
Thanks & All the best,
Nawaf