Is it possible to create a hyperlink that stays on the current page even if the worksheet tab is renamed?

Your question doesn't provide enough information.

A hyperlink ON the cell (via CTRL-K to open the hyperlink feature) links to anywhere. The name of the sheet is not relevant.


Text entered into a cell that Excel determines resolves to a hyperlinkable location is creating a CTRL-K type hyperlink.

The =HYPERLINK() formula can link to a different part of the workbook using text strings to create the link. That could fail if the other sheets were subsequently renamed.

Ok, I kind of botched the question. More to the point, is there a "generic" way to do this: Sheet1.Name reference? I want not specifically Sheet1 but "whatever sheet is active now".Name. The isdea is I want to use the tab name to create a filename for saving stuff from the current active sheet. Has nothing to do with hyperlinks, sorry for the misleading question. That was another days problem...

Thanks,
Bill

Have you tried ActiveSheet.Name?