Restrict Table Edits of iParts

[dsouva]

I was wondering if there is a good way (preferably through iLogic) to restrict the user from making table edits and force them to edit the excel file. Ideally, open the excel table instead of the table edit dialog. Any suggestions? 

[A.Acheson]

Hi @dsouva 

I don't think there is any method to prevent the user from editing excel only. I assume the user is modifying the iParts manually and not by code? What is the undesirable effect in not editing through the excel sheet?

[dsouva]

The excel sheet includes excel formulas with logical functions to calculate other values. 

[A.Acheson · Accepted solution]

There is a way using control definitions. 

ThisApplication.CommandManager.ControlDefinitions.Item("AppCreateipartCmd").Enabled = False

[dsouva]

@A.Acheson works perfectly! Thanks!