Custom functions in TEAM's Excel sheet

[lkurdubelski]

Hello,

I was using custom function created in VBA in a desktop version of my file. But due to high usage of file (many people need access to the file, and many of them will try to edit it simultaneously) I decided to migrate the file to the teams version of excel, where it can be edited by few users at the same time.

I found that my custom function (which detect if a cell is Strikethrough) isn’t working at all.

I found (reaching excel help pages) that VBA macros are not supported in teams version of excel.

Is there any way to use custom function in teams excel? If so how to do that?

[#2]

If they perform calculations, rewrite them using Lambda functions and other worksheet formulas. If, as appear to be the case, you require use of parts of the Excel object model that are not available from the user interface, rewrite the functionality using Typescript macros. Some features (shapes and possibly event handlers) never will be implemented online.