Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel crashes while opening excel file imbeddied with macros | Excel Discussion (Misc queries) | |||
Saving Macros | Excel Discussion (Misc queries) | |||
Enabling macros | Excel Discussion (Misc queries) | |||
sorting with macros | Excel Discussion (Misc queries) | |||
Transferring toolbars and macros to other computers | Excel Discussion (Misc queries) |