Results 1 to 3 of 3
  1. #1
    5 Star Lounger jujuraf's Avatar
    Join Date
    Jun 2001
    Location
    San Jose, California, USA
    Posts
    1,061
    Thanks
    0
    Thanked 0 Times in 0 Posts

    add button to chart sheet (Excel 2000)

    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 <img src=/S/groovin.gif border=0 alt=groovin width=21 height=21>

  2. #2
    3 Star Lounger Jim Cone's Avatar
    Join Date
    Feb 2002
    Location
    Portland, Oregon, USA
    Posts
    238
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: add button to chart sheet (Excel 2000)

    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

  3. #3
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Silicon Valley, California, USA
    Posts
    273
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: add button to chart sheet (Excel 2000)

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •