Re: $$Excel-Macros$$ go back to the last visited page

Hi Thanks for the file, nice work. But what I am require the program has to remember all the sheets in the order I opened them. I think it may require to make a log file to record the opened sheets so it can go back the reverse order.it is not just for go back but I want to make a code which copy p

Re: $$Excel-Macros$$ go back to the last visited page

Please see attached file Chilexcel 2011/5/9 rajan verma > HI, > Please see if it help.. > > > On Sun, May 8, 2011 at 4:01 PM, Rajesh K R wrote: > >> Hi Experts >> Is it possible to create two buttons one for forward & other for >> backward and move to sheets in the order what we used after l

Re: $$Excel-Macros$$ go back to the last visited page

Hi The xlsm file is not open in my computer will u send the code inside it. Regards Rajesh Kainikkara On 5/9/11, rajan verma wrote: > HI, > Please see if it help.. > > On Sun, May 8, 2011 at 4:01 PM, Rajesh K R > wrote: > >> Hi Experts >> Is it possible to create two buttons one for forward & o

Re: $$Excel-Macros$$ go back to the last visited page

HI, Please see if it help.. On Sun, May 8, 2011 at 4:01 PM, Rajesh K R wrote: > Hi Experts > Is it possible to create two buttons one for forward & other for > backward and move to sheets in the order what we used after login just > like we do in a browser.Pls check the attachment > > Regards > R

Re: $$Excel-Macros$$ go back to the last visited page

Sub backward() If ActiveSheet.Index = 1 Then Exit Sub Else Sheets(ActiveSheet.Index - 1).Activate End If End Sub Sub forward() If ActiveSheet.Index = Sheets.Count Then Exit Sub Else Sheets(ActiveSheet.Index + 1).Activate End If End Sub On Sun, May 8, 20