How to protect excel sheet in d365fo

(0) Share

Report

Posted on by js lee

Hello.

I asked 2 questions, but I didn't get the answer I wanted, so I'm writing.

I want to do 'excel sheet protection' when I make excel file in d365fo, but I only got indirect answers.

I want a direct code that does excel sheet protection.

Thank you for reading the question

I have the same question (0)

All responses (2)

Answers (0)

js lee 25 on at

Like (0)

Report

How to protect excel sheet in d365fo

After many attempts, we succeeded as follows

ExcelSheetProtection _Protection = worksheet.protection;

_Protection.isProtected = true;
_Protection.SetPassword("123");
package.Save();

Was this reply helpful? Yes No
Martin Dráb 236,958 Most Valuable Professional on at

Like (1)

Report
How to protect excel sheet in d365fo

Good! I'm glad you found in the end that the approach I suggested indeed solves the problem.

For reference, the discussion is split to three threads with the same name. If anyone is interested in details, please refer to them.

https://community.dynamics.com/forums/thread/details/?threadid=f5caef5f-ec3f-ee11-bdf3-000d3a55bcf1

https://community.dynamics.com/forums/thread/details/?threadid=bab21374-2843-ee11-bdf4-00224827e5da

js lee, please use replies next times, instead of creating several new threads on the same topic.

Was this reply helpful? Yes No

Join the conversation

Community site session details

How to protect excel sheet in d365fo

Helpful resources

Quick Links

Responsible AI policies

Pallavi Phade – Community Spotlight

Congratulations to the October Top 10 Community Leaders!

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

Featured topics

Product updates

Community site session details

How to protect excel sheet in d365fo

Helpful resources

Quick Links

Responsible AI policies

Pallavi Phade – Community Spotlight

Congratulations to the October Top 10 Community Leaders!

Subscribe to this forum!

Select categories

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

Featured topics

Product updates