Im working on a excel project where i need some kind of menu to navigate
through weeks and days. There is one excel page for each day of the week and
all 52 weeks included in one excel document, there is also a sumary.

I need a way of doing a menu so when you click on for example week 6
Monday-Sunday for that week comes up, perferably as a "sub-menu".

Is there any way of either making a menu with VBA or macros to have a menu
come up/down for a specific week so if you have tabs or buttons for week 1-52
and you click on one of them a new menu comes forth.