Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Worksheen name referencing to create a 'back' button hyperlink
Hi, I'm trying to use Excel as Internet looking database to look after varios suppliers we use. it uses lots of worksheets with hiperlinks all over the place that takes you to other areas of the workbook you want to go to. I've got over 60 worksheets that produce various graphs on each one but all automatically generated from one pile of source information worksheet so no trouble to update. All thats different on each worksheet is the name of the supplier at the top and then all the rest sorts itself out, its working really well and I have 5 macros on each worksheet which use the name at the top on each to then go away and generate various reports on a seperate worksheet, so all I have to do is copy a macro button onto each worksheet and it works fine for the new worksheet when I copy it across. What I'd like though is when the macro generates the report, for it to also add a hiperlink back to the worksheet you were looking at. I can't use the name of the supplier at the top as its not identical to the name of the worksheet due to excels limitations as to what you can type in the tabs. Is there and way when writing a macro I can get it to refrence the name in the worksheet tab I'm currently on and then creating a hiperlink, later on I can then use it to write the hipelink in the macro after the report is generated to jump back to the supplier worksheet you were on. all I have to do is copy that script into the other four macros and for all of the 60 plus tabs, will give you the option of a 'back' button hope I made some sence and someone can help..... -- Paul Adams ------------------------------------------------------------------------ Paul Adams's Profile: http://www.excelforum.com/member.php...o&userid=10468 View this thread: http://www.excelforum.com/showthread...hreadid=566701 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Worksheen name referencing to create a 'back' button hyperlink
Nobody can help? -- Paul Adams ------------------------------------------------------------------------ Paul Adams's Profile: http://www.excelforum.com/member.php...o&userid=10468 View this thread: http://www.excelforum.com/showthread...hreadid=566701 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a hyperlink to a cell with the hyperlink function | Excel Worksheet Functions | |||
Please Help Me with Custom menus | Excel Worksheet Functions | |||
Drag file from browser into Excel to create hyperlink. | Excel Discussion (Misc queries) | |||
How do I execute command from button or hyperlink? | Excel Discussion (Misc queries) | |||
Macro to simply bring up the Find dialogue box?? | Excel Discussion (Misc queries) |