Macro enabled workbooks

[gothe4dog]

I am designing a macro enabled worsheet for BA but BA won't recognise it on connection saying 'Workbook does not contain BA worksheet'

If a call the worksheet .xls the VBA does not work.

[TheTub]

You need to use .xls files. I have hundreds all with macros running nicely. It doesn't have to be .xlm to have macros enabled.

[Vildan]

It also depends what version of xl you are running. In 2003 you can address this issue in security settings and allow macros.