Forum Discussion

Shonte6708's avatar
Shonte6708
Copper Contributor
Sep 02, 2019

Family tree template

I am using a template that I found in excel templates. It is macro-enabled. When I changed the names and added to it, the family tree doesn't populate  

developer
excel
Macros and VBA
office 365

2 Replies

  • erol sinan zorlu's avatar
    erol sinan zorlu
    Iron Contributor
    Sep 02, 2019
    Did you check the "macro security"? This option is under File-->Options-->Trust Center, Trust Center Settings. If it is set to "Disable all macros without notification" the macros in macro enabled workbook will be omittedn and won't work.
    • Hanani1952's avatar
      Hanani1952
      Copper Contributor
      Apr 27, 2021
      hi,
      I am using office 365 for Mac and I don't see this option to find the trust center under: File as suggested.

      I did however changed it somewhere else but still when I "create a family tree" only names of grandparents are created and none of the other columns are updated.

      Any idea ? Many thanks