Skip to Content

Attaching VBA Macro in MDT Workbook

Jan 15 at 06:36 PM


avatar image

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



10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

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.


10 |10000 characters needed characters left characters exceeded