ExcelBanter - 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