I am trying to create a calendar (a worksheet) that will do the following.
1) It will be daily
2) All days will be in yellow color (the cell color not the text color)
3) When click on a day, a sheet will be opened named under Date that will contain the contents of table (table attached) where we can make entries (numeric). When all the table is full (or some of it / or the day is over) the day (calendar date & sheet) will change color to red and Hide sheet.
Can this be done?