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).
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