How to disable System defined Open in Excel menu button on a particular form

(0) Share

Report

Posted on by Dinesh Tyagi

Hi,

I want to disable Open in Excel Button which is system defined button. need to do it on a particular form like custTable or vendTable.

their is some code written over there in custTable but not getting how to execute.

Thanks,

Dinesh

I have the same question (0)

All responses (7)

Answers (2)

Dinesh Tyagi 61 on at

Like (0)

Report

How to disable System defined Open in Excel menu button on a particular form

Hi Andre,

Thanks for your reply, your suggested solution works perfectly fine.

Thanks,

Dinesh

Was this reply helpful? Yes No
Verified answer

André Arnaud de Cal... 298,193 Super User 2025 Season 2 on at

Like (0)

Report

How to disable System defined Open in Excel menu button on a particular form

Hi Dinesh,

You don't need to extend privileges. You need to ensure you have security roles with duties that does not contain this specific privilege. Prevent changing standard security objects. It would be better to create and manage your own if you need different behavior compared to the standard roles.

Was this reply helpful? Yes No
Dinesh Tyagi 61 on at

Like (0)

Report

How to disable System defined Open in Excel menu button on a particular form

Hi Nikolaj & Andre,

I checked their is one security privileges which contains customerEntity, customerEntityV2 & customerEntityV3. But can't extend the privilege to remove these entities from its permissions. So can you pls clear how can I do that.

Thanks & Regards,

Dinesh

Was this reply helpful? Yes No
Dinesh Tyagi 61 on at

Like (0)

Report

How to disable System defined Open in Excel menu button on a particular form

Hi Girish,

I have tried this way but getting error: object reference not set to an instance of an object. That officeButton is null.

[ExtensionOf(FormStr(CustTable))]
public void init()
{
FormCommandButtonControl officeButton;
#SysSystemDefinedButtons

next init();

officeButton = this.control(this.controlId(#SystemDefinedOfficeButton)) as FormCommandButtonControl;
officeButton.visible(false);
}

Thanks,

Dinesh

Was this reply helpful? Yes No
Verified answer

André Arnaud de Cal... 298,193 Super User 2025 Season 2 on at

Like (0)

Report

How to disable System defined Open in Excel menu button on a particular form

Hi Dinesh,

I agree with Nikolaj. You can manage which entities are visible for used in 'Open in Excel' with help of security. In case you remove the data entities currently listed from their permissions, the list with options for Open in Excel will be empty. Note that Export to Excel will be then still visible.

Was this reply helpful? Yes No
Suggested answer

NikolajSorensen 1,784 on at

Like (0)

Report

How to disable System defined Open in Excel menu button on a particular form

This should be controlled by the security configuration.

Access to the entities defines if users are able to interact with the data through functions such as "Open in Excel".

You will need to modify or build new security roles, where you simply do not grant access to the entities in question.

Was this reply helpful? Yes No
Suggested answer

GirishS 27,825 Moderator on at

Like (0)

Report

How to disable System defined Open in Excel menu button on a particular form in D365FO

Hi Dinesh,

I think with the help of "SysSystemDefinedButtons" macro you can hide the System defined buttons.

For open in excel the button name is "SystemDefinedOfficeButton".

Refer to the below Microsoft documentation for disabling system defined buttons through code.

https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/user-interface/system-defined-buttons

You can refer to the last section in the above link.

Thanks,

Girish S.

Was this reply helpful? Yes No

Community site session details

How to disable System defined Open in Excel menu button on a particular form

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Andrés Arias – Community Spotlight

Congratulations to the August Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

How to disable System defined Open in Excel menu button on a particular form

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Andrés Arias – Community Spotlight

Congratulations to the August Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates