• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

ASK-Help to navigated this excel

masfajar

New Member
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
 

Attachments

  • lapbul.xlsx
    17.6 KB · Views: 5
Back
Top