add button to chart sheet (Excel 2000)

Topic

New Reply

Hi there,
I have a chart sheet and want to add a button to it (from the Controls toolbox). Is this possible? I can’t seem to drop the button on to the sheet so I think the answer is no, but I’ve never used chart sheets before (always just embedded the chart on a worksheet).

I’m adding some code to a co-worker’s .xls file and not sure yet if I can replace the chart sheet with a regular worksheet if that solves the problem.

Thnx, Deb

Reply | Quote

Replies

Deb,

After much searching, the following is from somewhere in the Excel 2002 help file…

“What the controls can’t do
You cannot use ActiveX controls on chart sheets or XLM macro sheets.
For these situations, use the Forms toolbar controls.
If you want to attach a macro to run directly from a control, use a Forms toolbar control.”

To me ,this says you must use the controls from the Forms toolbar on chart sheets.

Jim Cone
San Jose, CA

Reply | Quote

I had the same problem, and used the recommended solution (use a button from the Forms toolbar).

I just chalk it up to an inconsistency and bear with it.

Reply | Quote