navigate sheet onclick
 

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

navigate sheet onclick
 

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

navigate sheet onclick
 

thanks friend


--
nshanmugaraj
------------------------------------------------------------------------
nshanmugaraj's Profile: http://www.excelforum.com/member.php...o&userid=31570
View this thread: http://www.excelforum.com/showthread...hreadid=515633