Share via

Enable Excel 4.0 macros when VBA macros are enabled box is missing

TW Koh 1 Reputation point
2021-09-07T14:37:02.867+00:00

I need to run functions from an XLL. I cannot run demonstrate this XLL on a friend's machine. When I looked at the Trust Center Settings -> Macro Settings, the option for 'Enable Excel 4.0 macros when VBA macros are enabled box' is missing.

Microsoft 365 and Office | Excel | For business | Windows
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Emily Hua-MSFT 27,796 Reputation points
    2021-09-08T05:39:49.357+00:00

    @TW Koh

    Please check the version of Office on your friend's machine, as not all releases of Office has this feature box, such as Office professional Plus 2019.

    If your friend is runing Microsoft 365 apps, it's recomended to check the version number and the update channel.
    According to the Microsoft roadmap, this option is option was launched in May of this year. Please make sure the version is newer than Version 2104 (Build13929.20296).
    130077-image.png

    Any updates, you may post back.

    If an Answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.