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;
- Jun 22 Fri 2007 20:38
macros
close
全站熱搜
留言列表
發表留言