Skip to Content
author's profile photo Former Member
Former Member

Macro error in analyzer

Hi All,

When i create any button and assign some command like save_area in analyzer design mode, it is giving the below error when i click on this button upon execution.

"Cannot run the macro 'DesignIconClicked'. The macro may not be available in this workbook or all macros may be disabled"

I am using Excel 2007, and in macro settings,

i set "Enable all macros" and "Trust access to the VBA project object model".

How to fix this. This error is coming for dropdown boxes as well.

Thanks

Bindu

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    Posted on Nov 07, 2008 at 10:30 AM

    Hi Bindu,

    There has been lot of instances where consultants are facing the problem wrt Excel 2007.

    Just check with Excel 2003 ; Before that what security level have you put your Workbook in ???

    Below links may be helpful to you.

    link :

    [bi-ip-and-bex--save-button-does-not-work]

    [sap-gui-640-bex-analyser-problem-run-time-error;

    Thanks

    Pratyush

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 07, 2008 at 10:34 AM

    After opening excel 2007, on top of the screen, you will find one down facing arrow for "customize quick access toolbar". Click on that and click on more commands. It opens one more window for excel options. Click on Add Ins on the left side of that window. On the right side, it shows all the add ins in your excel. At the bottom, you have a drop down box for manage. Click on that drop down and select disabled items and click on go. Select the "DesignIconClicked" and click on Enable.

    <removed by moderator>

    Edited by: Siegfried Szameitat on Nov 7, 2008 12:05 PM

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      When you open the list of the add ins, do you have that available in your list. If its not there, then it needs to be installed. If its available in the inactive add ins, try to import it in your add ins folder.

      Please award points if helpful.

  • Posted on Nov 11, 2008 at 08:35 AM

    Hi,

    It should also work with Excel 2007 with ad -ins

    Please checkthe below notes for your ref

    877774 - Pre-requisite for BI 7.0 Frontend

    918394 - BI Frontend installation check tool

    1050605 - No response for the toolbars in BEx Analyzer 2004s

    1049712 - Applying Patches for NetWeaver BI Frontend

    930350 - Termination in Web Application Designer when you Drag & Drop

    Thanks

    Pratyush

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.