how to open worksheet with botton

  • i have a main page with 2 bottons e.g (pump1)&(pump2) i would like each botton to open its own worksheet but i dont want to see tha tab for the worksheets that the bottons have to open. all this is done in the same workbook.

    i try recording a macro by clicking on the worksheet tab that i want the button to open but it only works when the worksheet is not hidden . i do not know much about VB can some 1 help me please :? :thanx:

  • Re: how to open worksheet with botton

    Try going to Tools> Options> uncheck the Sheet Tabs.

    Hope that helped

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!