Adding a button to a chart

PhilWalker · Mar 5th, 2002, 06:15 AM

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 · Mar 5th, 2002, 06:23 AM

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 · Mar 5th, 2002, 06:26 AM

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

try this...

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 5th, 2002, 06:15 AM	#1
PhilWalker New Member Join Date: Mar 2002 Posts: 1	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

Mar 5th, 2002, 06:23 AM	#2
mrowe Board Regular Join Date: Feb 2002 Posts: 232	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.

Mar 5th, 2002, 06:26 AM	#3
mrowe Board Regular Join Date: Feb 2002 Posts: 232	Sub goto_front_page() Sheets("front_page").Select End Sub try this...