question

excel-user avatar image
0 Votes"
excel-user asked emilyhua-msft commented

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

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.

office-excel-itpro
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

emilyhua-msft avatar image
0 Votes"
emilyhua-msft answered emilyhua-msft commented

@excel-user

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.


image.png (7.5 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@excel-user
I am checking the status of this issue. Do you have any update for it?
If yes, please feel free to post back.

0 Votes 0 ·