VBA code for a command button

[zvonacfirst]

Hi.

Please help me.

I need the VBA code for a command button.
This button I want to open a sheet, in a dynamic mode, considering a value from a cell.
I've attached a workbook.
Thank you.

[mikerickson]

If you assign this macro to the button, it should do what you want

Please Login or Register  to view this content.

[zvonacfirst]

Thank you. It works!!! You made me happy.

May I have another question?
Please see the sheet A1.
There is another Command button that it should make three commands:
- Save doc
- Go to Main Sheet
- Clear contents for cells B5 and D5

Thanks!!!

[mikerickson]

You can record macros to find the syntax for all of those operations.
And then assign then to the buttons. You, and your users, might prefer three command buttons to one.

[zvonacfirst]

I have already done. It works perfectly.
Thank you a lot.

[zvonacfirst]

Hi.

Another question I have for you.
I attached an Excel file.
There is a sheet named Main and three sheet named Sheet2, Sheet3 and Sheet4.
In cell B2 in Main sheet I can made a selection, I mean about the names of Sheet2, 3 or 4.
I wish the Main be permanently visible and Sheet2, 3 and 4 be permanently hiden.
I need a VBA code that should make next: if I select in B2 Sheet2, the code should unhide the Sheet2 and open it, and the same with the Sheet3 and Sheet4.
Thanks.