Search code examples
exceloffice-jsoffice-addinscustom-functions-excel

How to hide Developer Window when calling Excel Office.js custom function


I'm writing an Excel add-in using Office.js that contains custom functions and would like to know if there is a way to prevent the Developer Window from opening when I call a custom function.

The blank 'functions.html' page from manifest.xml <bt:Url id="Functions.Page.Url" DefaultValue="https://localhost:3000/functions.html" /> opens whenever I call the function for the first time after loading the add-in.

Using Excel for Mac (16.32).


Solution

  • Please execute the following command on your Mac machine:
    defaults write com.microsoft.Excel OfficeWebAddinDeveloperExtras -bool false

    You can find more information about it at:
    https://learn.microsoft.com/en-us/office/dev/add-ins/testing/debug-office-add-ins-on-ipad-and-mac

    Please let us know how that works.

    Thanks,
    Zlatko