Attaching VBA Macro in MDT Workbook

[sourojit_pal]

Hi Experts,

In order to set data validation for some of the attributes, I have created a VBA Macro and tried to implement it on the MDT Workbook. But, the attached Macro is lost whenever I am closing the workbook.

Please suggest if there is any specific way to attach VBA Macro to MDT workbooks.

I am currently using IBP 1711 excel Add-on

Regards,

Sourojit

[chakon · Accepted solution]

Hi Sourojit,

I am not a VBA expert, but there are some VBA hooks available which you can use to do validation. And VBA Macro you can add like

File-->Options-->Add-in-->Excel Add-in and select your Macro code file . Open your macro excel and save as excel add-in ( it'll suggest a file path) save it in that folder.

Thanks,
Chandra