macros
 

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: http://www.excelforum.com/member.php...o&userid=31119
View this thread: http://www.excelforum.com/showthread...hreadid=507864

macros
 

Are you using macros for navigation or what? What is the purpose of the "go
to"? Why not just use hyperlinks? If you want a "table of contents", try
this:
http://vbaexpress.com/kb/getarticle.php?kb_id=120
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

"rubbershark"
wrote in message
...

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:
http://www.excelforum.com/member.php...o&userid=31119
View this thread: http://www.excelforum.com/showthread...hreadid=507864