So what have you tried, and what do you get?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"KyleGrey" wrote in message
...
Hey there, I'm really new to macros but have come along way (at least
i think)
Heres my problem:

Im trying to set up a system for a roster whereby i can enter staff
availability into one workbook which shows up as grey on workbook 2.
I want to set it up so that i can enter a "yes" (rostered work) into
the grey areas i choose without losing the grey. And i dont want grey
areas to be created if i accidently add a "yes" to a white area. Nor
do i want the grey areas established to be deleted. Any help?
Thanks

Kyle