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: