navigate sheet onclick

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

nshanmugaraj - 23 Feb 2006 06:27 GMT

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

Signature

nshanmugaraj

Reply to this Message

NAVEEN - 23 Feb 2006 06:42 GMT

Hi,

Create a macro as follows

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

Assign this macro to a button.

Regards,
NAVEEN

> 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

Reply to this Message

nshanmugaraj - 23 Feb 2006 10:27 GMT

thanks friend

Signature

nshanmugaraj

Reply to this Message