Forum Discussion
Reference sheet numbers in hyperlink
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(...
to do it in a macro the code would be like:
ActiveWorkbook.Sheets(n).Activate
where n is the sheet number