Alternate proposal Instead of creating the links in each sheet dynamically, I think it is easy to create a customised toolbar with two buttons for your purpose, which can be used on any sheet, that is active.
Regards, Kishan Reddy, K On Aug 23, 7:21 pm, shariqcoo...@gmail.com wrote: > Hi, > > Can any one tell me how we can link the macro code to hyperlink. > > I want to navigate the sheet by click the next or previous by using > > Activesheet.next.select or activesheet.previous.select > > And I want this two link on each sheet present on my work. > > Just for your information the sheets are dynamically add as per the logic > applied on back end they could be one or 100. > > Thanks > Shariq > Sent on my BlackBerry® from Vodafone -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
