navigate sheet onclick

[nshanmugaraj]

hi
i am new to excel programming

i am in sheet1.. when i click a button i should go to sheet5...


kindly send me the coding ... i will be thankfulll

[NAVEEN]

Hi,

Create a macro as follows

=============================
Sub NavigateSheet()
Sheets("sheet5").Select
End Sub
=============================

Assign this macro to a button.

Regards,
NAVEEN



"nshanmugaraj" wrote:

>
> hi
> i am new to excel programming
>
> i am in sheet1.. when i click a button i should go to sheet5...
>
>
> kindly send me the coding ... i will be thankfulll
>
>
> --
> nshanmugaraj
> ------------------------------------------------------------------------
> nshanmugaraj's Profile: http://www.excelforum.com/member.php...o&userid=31570
> View this thread: http://www.excelforum.com/showthread...hreadid=515633
>
>

[nshanmugaraj]

thanks friend