MrExcel.com - Your One Stop for Excel Tips & Solutions

Controls in a Chart Sheet

Posted by Stan on October 11, 2001 11:58 AM

Am I correct in saying that a control cannot be put into a Chart sheet? When I call up the Toolbox, there are no control options enabled.

Cheers

Stan

Posted by Damon Ostrander on October 11, 2001 10:03 PM

Hi Stan,

I believe you are correct that you cannot put ActiveX controls (from the Controls Toolbox) on a Chart sheet. However, you CAN put Forms controls from the Forms toolbar onto a Chart sheet. In addition you can add graphics (Shape or Drawing objects) to a Chart sheet and assign a macro to them so that they act as a commandbutton.

Damon