Reference sheet numbers in hyperlink

Question

I want to be able to link a specific shape to a sheet by the sheet number, not its name.

Using the standard method, by selecting 'hyperlink', only a list of sheet names appear.

Inserting a onclick() macro into the initial sheet would work but I cannot figure out how to reference a sheet by its number.

All help appreciated.

m_tarler · Answer

to do it in a macro the code would be like:ActiveWorkbook.Sheets(n).Activatewhere n is the sheet number&nbsp;

petesw · Answer

Thank you for your response. I will try it out when I return to my office next week.

Forum Discussion