Need button in workbook that links directly to a chart.

A

aschroer

I would like a button or hyperlink I can insert into a cell in a large
spreadsheet that links to a chart sheet in the same workbook or a different
workbook.
 
E

ewan7279

Hi,

To link to a sheet in the same workbook:

Insert => Hyperlink => Place in this document, then select the sheet you
wish to link to and enter the cell reference if required (default is A1).

To link to a sheet in another workbook:

Insert => Hyperlink => Existing fiule or webpage, then browse to or enter
the filepath.

Ewan.
 
Top