Calendar, hide sheet based on day color and more

makis1023

New Member
Joined
Jun 16, 2021
Messages
18
Office Version
  1. 365
  2. 2013
Platform
  1. Windows
Hi all,

I hope you can help me (otherwise my gf will loose her work...).
I have to make an excel that It will contain a calendar (daily per month).
If the calendar can be done with a drop down menu (choose month), or even better button (vba) to make month choice it will be great.
Now, the calendar will be used to a bar. With this excel employees will insert the closing of the day, amount (only money).
So what I need to do is that , lets say that the calendar is in sheet1, June 30 days. All cell dates will have yellow color. When I press i.e. Day 25 a sheet will unhide with that date as a name (25062021) In there the bar crew will need to insert all the necessary info for the day. When all data have be inserted, the cell of the calendar day will turn to Red (meaning that day is closed and ready).
Also, if it is possible when press that day (25) and the cell is red to unhide 25062021 sheet in order boss to see that day.
I know how to hide / unhide sheets based on cell value (vba) but I am stuck on all others.
Can someone please tell me what to do, give me some directions as I am not good on VBA.

Thank you in advance,

Sheet Contents

calendar1.xlsx
ABCDEF
1ZONE Α (10:00- 18:00)
Φύλλο1
 

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

makis1023

New Member
Joined
Jun 16, 2021
Messages
18
Office Version
  1. 365
  2. 2013
Platform
  1. Windows
No one? At least a hint. Something? I can create calendar ok, but the others.

Thank you!!!
 

Forum statistics

Threads
1,143,677
Messages
5,720,260
Members
422,273
Latest member
linds75

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top