HaRsh MeVada

HaRsh MeVada

  • 1.7k
  • 46
  • 2.3k

how to track macros vb script code changes in Excel plugin?

Feb 19 2016 7:40 AM
i have created one excel plugin in visual studio.
i have created a macros based sheet in excel which has .xlsm extension.you can view and edit macros which you have created under the ribbon named "View".
if you edit macros then you will be able to see the sheet information in vb code ,you can change your cell value from vb code and save the vb project
now my requirement is to track that change which you have done in vb project(like track changes functionality which is already featured in excel) and i am doing all this process from excel addin.
 
how can i get the track changes data that are done through vb code?