Hi,
To organize the colleague holidays into my offices, I want to use one xls file.
The user can type 4 or 8 h in a calendar day only when into her office two people not will be in holiday in the same time.
Ex: quality office 6 people, only the first two gay that reserve a same day can going in holiday, the 3th can't!!.
But in the 1th case VBA run and my control too, in the 2th not, but any case operator can input reserve a holidays day
I try to use the Ken Plus solution: [vba]vbaexpress.com/kb/getarticle.php?kb_id=379[/vba]
but this app conflicts with my checks.
My file is here [vba]fcarboni.com/forum/holiday2012.xls[/vba], somebody can help me?.
1th sorry for my bad english 2th thank any case
Fabrizio