Start Macro since open a workbook

[Former Member]

I am using BI 7.0 and try to figure out, how can I execute my macro for formatting a Table new, while open the workbook.

The macro I have empted always start when I push the refresh button, not during the open process.

I selected u201CRefresh Workbook on openu201D already.

Thanks for any answer

Best Regards,

Matthias

[Former Member]

In your workbook, go in the VBEditor, and search for your workbook in the left pane.

there is, for each workbook, an event triggered, and a sub named Workbook_Open().

Put your code here.

[Former Member]

Hello I Try to work with the macro Workbook_Open(), bud SAP reformatted my table after processing this marco.

[Former Member]

the problem was that the BexRepositorySheet was protected. With

Sheet1.Unprotect Password:=""

it works fine

[pavel_afanasiev]

do you want to re-format the workbook every time it is open, or do you want to apply formatting after the results of a new query displayed?

[Former Member]

I want to apply formatting after the result of a new query displayed!