macro to select worksheet for active

[kalpeshpatel]

Hello,


my workbook contain many worksheet


i want to create a macro in sheet1 to select other worksheet


e.g.


when click command button go to the worksheet2


how possible it

 

[Luke M]

In a module in the VBA.

[pre]

Sub SelectSheet2()
Worksheets("My Sheet").Select
End Sub

[/pre]
Then, assign the macro to your command button.

 

[SirJB7]

Hi, kalpeshpatel!

Give a look at this:

http://www.2shared.com/file/TSaa_uNp/macro_to_select_worksheet_for_.html

Regards!

 

[SirJB7]

Hi, kalpeshpatel!

Here it is in 4shared, file in 2shared was unreachable:

http://www.4shared.com/file/W8uMuDCe/macro_to_select_worksheet_for_.html

Regards!