Skip to Content

Attaching VBA Macro in MDT Workbook

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Jan 30 at 05:44 AM

    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

    Add comment
    10|10000 characters needed characters exceeded