• add button to chart sheet (Excel 2000)

    Author
    Topic
    #372164

    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 groovin

    Viewing 0 reply threads
    Author
    Replies
    • #593970

      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

      • #594318

        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.

    Viewing 0 reply threads
    Reply To: add button to chart sheet (Excel 2000)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: