Forum Discussion
aimonFatima
Jun 23, 2020Copper Contributor
How to lock certain excel cells or make them read-only using X++in AX?
Hi All, I'm new in this community working in Microsoft Dynamics 365 F&O . Looking forward to gain more knowledge from all of you.. I want to lock some of excel cells (not all) using X++ in my...
JKPieterse
Jun 23, 2020Silver Contributor
I don't know X++, but I do know that in Excel protecting cells consists of two things:
- Setting locked property to False for cells that must be editable (default is True)
- Protecting the worksheet in question
- Setting locked property to False for cells that must be editable (default is True)
- Protecting the worksheet in question