Create button to open sheet

[tryingtolearn]

I have code that creates a new sheet in the active workbook and requires input to name the sheet. My problem is that I also need to create a button on sheet1 that opens the newly created sheet and names the button the same as the sheet name.

This is my code for creating the new sheet that works fine.

Please Login or Register  to view this content.

Can anyone help me?

[john55]

hi!
please use code tags!

[tryingtolearn]

Hi John,

Sorry I do not know what you mean. I am new to all this.

[john55]

no problem!
see
"3. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Select your code and click the [#] button at the top of the post window (if you are editing an existing post, press Go Advanced to see the [#] button). The result will appear like this in the post window:"

http://www.excelforum.com/forum-rule...rum-rules.html

[tryingtolearn]

I think I got,

Please Login or Register  to view this content.

[tryingtolearn]

Thak you John for your help with posting code. Much appreciated.

[john55]

is this what you want?

Please Login or Register  to view this content.

[tryingtolearn]

Hi John,
this is what I have so far and in the triple brackets is what I need to do. This works well if I refer to an existing macro to open a sheet.

Please Login or Register  to view this content.

Hope I have explained my situation properly. Thanks for your interest.