Tab name link

[#1]

HI ALL,

I have 7 tabs..I want to show link of tabs when I am going from 1 tab to another..

for eg.

If I am going from tab 1 to 3.....I want to show 1->3 in tab 3

If I am going from tab 5 to 3.....I want to show 5->3 in tab 3

Can anyone know how to do this?

[sbaldwin]

Hi, you could add a trigger to each of your sheets that will set the value of some variable with the sheet number you are leaving then use the =getactivesheetid in a text box on each of your sheets.

I have attached an example of this working.

Thanks

Steve

[#3]

Thanks steve...Its working fyn