dear all
can you help me created navigate menu with this structure :
sheet Menu1 --> (button menu) (button menu)
January --> Sheet Menu 2 --> * Menu1jan, Menu2jan
February * Menu1feb, Menu2jfeb
March * Menu1march, Menu2march
April * Menu1 April, Menu2April
and i want hyperlink to hidden sheet .
example :
* when i click button menu january will show button menu1jan and menu2jan hyperlink to sheet sheetmenu1jan and sheetmenu2jan etc
*all sheet hidden , and if i go back to menu1 there are still hidden . so pure if i want go to another sheet just by hyperlink button
i think macro will be help .
anyone help me
can you help me created navigate menu with this structure :
sheet Menu1 --> (button menu) (button menu)
January --> Sheet Menu 2 --> * Menu1jan, Menu2jan
February * Menu1feb, Menu2jfeb
March * Menu1march, Menu2march
April * Menu1 April, Menu2April
and i want hyperlink to hidden sheet .
example :
* when i click button menu january will show button menu1jan and menu2jan hyperlink to sheet sheetmenu1jan and sheetmenu2jan etc
*all sheet hidden , and if i go back to menu1 there are still hidden . so pure if i want go to another sheet just by hyperlink button
i think macro will be help .
anyone help me