Adding a button to a chart

[PhilWalker]

I have 26 charts in a workbook and am able to access them from a "Front Page" by populating a combo box with their names. The problem is that I can't put a return button in the corner of each chart as most items on the control toolbox are greyed out. Hyperlink is also greyed out. Dous anyone know how I can get back to my "Front Page"?
Thanks in anticipation,
Phil Walker.
My work email is phil.walker@astrazeneca.com
My home email is phil.walker3@btinternet.com

 

[mrowe]

record a macro that takes to to the front page from the active worksheet.

On the chart page add a button from the "Forms" menue and assign the macro to it - or you could assign the macro to a custom toolbar (then you only have to have 1 button for the entire sheet.

 

[mrowe]

Sub goto_front_page()
Sheets("front_page").Select
End Sub


try this...