Skip to Content
0

Attaching VBA Macro in MDT Workbook

Jan 15 at 06:36 PM

72

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

Regards,

Sourojit

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
0

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

Share
10 |10000 characters needed characters left characters exceeded