variable to refer to "this worksheet"?

C

confused

Hi,

I have a hyperlink function which when clicked opens another worksheet in
the same spreadsheet. At the moment my function is:
=HYPERLINK("[SpreadsheetName.xls]NewWorksheetName!Cell", "click here to open
new worksheet")

can I subsitute the spreadsheet name for something which refers to
"this/current spreadsheet". This means if the spreasheet name changes I wont
have to change the function.
Ive tried the following but neither work:
=HYPERLINK("[ThisWorkbook]NewWorksheetName!Cell", "click ...")
=HYPERLINK("[ThisWorkbook()]NewWorksheetName!Cell", "click ...")

thanks for any help you can give
cheers
 
D

Dave Peterson

See one more response at your other post.
Hi,

I have a hyperlink function which when clicked opens another worksheet in
the same spreadsheet. At the moment my function is:
=HYPERLINK("[SpreadsheetName.xls]NewWorksheetName!Cell", "click here to open
new worksheet")

can I subsitute the spreadsheet name for something which refers to
"this/current spreadsheet". This means if the spreasheet name changes I wont
have to change the function.
Ive tried the following but neither work:
=HYPERLINK("[ThisWorkbook]NewWorksheetName!Cell", "click ...")
=HYPERLINK("[ThisWorkbook()]NewWorksheetName!Cell", "click ...")

thanks for any help you can give
cheers
Click to expand...
 
Top