P
Paul Adams
Hi, I'm trying to use Excel as Internet looking database to look afte
varios suppliers we use. it uses lots of worksheets with hiperlinks al
over the place that takes you to other areas of the workbook you want t
go to. I've got over 60 worksheets that produce various graphs on eac
one but all automatically generated from one pile of source informatio
worksheet so no trouble to update. All thats different on each workshee
is the name of the supplier at the top and then all the rest sort
itself out, its working really well and I have 5 macros on eac
worksheet which use the name at the top on each to then go away an
generate various reports on a seperate worksheet, so all I have to d
is copy a macro button onto each worksheet and it works fine for th
new worksheet when I copy it across.
What I'd like though is when the macro generates the report, for it t
also add a hiperlink back to the worksheet you were looking at. I can'
use the name of the supplier at the top as its not identical to the nam
of the worksheet due to excels limitations as to what you can type i
the tabs.
Is there and way when writing a macro I can get it to refrence the nam
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 th
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 an
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....
varios suppliers we use. it uses lots of worksheets with hiperlinks al
over the place that takes you to other areas of the workbook you want t
go to. I've got over 60 worksheets that produce various graphs on eac
one but all automatically generated from one pile of source informatio
worksheet so no trouble to update. All thats different on each workshee
is the name of the supplier at the top and then all the rest sort
itself out, its working really well and I have 5 macros on eac
worksheet which use the name at the top on each to then go away an
generate various reports on a seperate worksheet, so all I have to d
is copy a macro button onto each worksheet and it works fine for th
new worksheet when I copy it across.
What I'd like though is when the macro generates the report, for it t
also add a hiperlink back to the worksheet you were looking at. I can'
use the name of the supplier at the top as its not identical to the nam
of the worksheet due to excels limitations as to what you can type i
the tabs.
Is there and way when writing a macro I can get it to refrence the nam
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 th
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 an
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....