Buttons do not work in Excel-based application

[zhumabek_amalbekov]

Hi all,

I have created an input redy Excel application in Bex Analiser with some buttons. Everything works fine, but when i  save the workbook and open again the buttons do not work.  A message shows like "unable to run a macros. Probably, that macros is not in current workbook or all macroces are switched off", my Office 2010 is not in english so its not exact message text. The buttons work only if i switch to designe mode and back again to dialog mode. Could anyone tell me how to solve it?

Thanks in advance,

Zhumabek

[zhumabek_amalbekov · Accepted solution]

Hi,

I have solve it.

Bex Design Toolbox: Workbook settings -> Refresh workbook on open -> Save workbook.

Thanks anyway.

Zhumabek

[Former Member]

Hi Zhumabek,

It's more to do with your excel settings.

1. Enable macro settings in excel by navigating to excel options -> Trust Center ->Trust Center Settings -> Macro Settings

2. Go to Popular tab in excel settings for including the new language for excel.

Br,

H