close

hi could anyone help me with a macro problem. can make a macro move in
the same as a linked sheets. the data is on 30 sheets going to one
master sheet. the master sheet contians 30 macros one for each sheet ie
goto page 2 goto page 2 up to 30 sheets. the links work fine but when i
sort the data the macros dont move with the sheet numbers. so when i go
back i end up on the wrong pages. can anyone help thanks--
rubbershark
------------------------------------------------------------------------
rubbershark's Profile: www.excelforum.com/member.php...oamp;userid=31119
View this thread: www.excelforum.com/showthread...hreadid=507864Are you using macros for navigation or what? What is the purpose of the quot;go
toquot;? Why not just use hyperlinks? If you want a quot;table of contentsquot;, try
this:
vbaexpress.com/kb/getarticle.php?kb_id=120
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

quot;rubbersharkquot; gt;
wrote in message
...
gt;
gt; hi could anyone help me with a macro problem. can make a macro move in
gt; the same as a linked sheets. the data is on 30 sheets going to one
gt; master sheet. the master sheet contians 30 macros one for each sheet ie
gt; goto page 2 goto page 2 up to 30 sheets. the links work fine but when i
gt; sort the data the macros dont move with the sheet numbers. so when i go
gt; back i end up on the wrong pages. can anyone help thanks
gt;
gt;
gt; --
gt; rubbershark
gt; ------------------------------------------------------------------------
gt; rubbershark's Profile:
gt; www.excelforum.com/member.php...oamp;userid=31119
gt; View this thread: www.excelforum.com/showthread...hreadid=507864
gt;

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()