News and Announcements icon

Dynamics 365 CommunityForums Finance forum How to protect excel s...

Finance forum

Unanswered

How to protect excel sheet in d365fo

(0) Share

Report

Report

Posted on by js lee

25

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

Categories:

Financial Management

All responses Img

All responses (2)

Answers Img

Answers (0)

Martin Dráb 228,971 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.
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();

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 290,665 Super User 2024 Season 2

#2

Martin Dráb 228,971 Most Valuable Professional

#3

nmaenpaa 101,150

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans