[Solved] Sheet protection in Calc

[DBGarfield]

I have a spreadsheet on which I record results of games in a tournament. At the end of the day, I use a macro to sort the players' records to find the winner.

I have the sheet protected so other users can't mess with the calculations. The macro unprotects the sheet, sorts the records, then protects the sheet again.

In the protection step, it brings up a dialogue box for password entry; I'm not using a password and would like the box to not appear. Is this possible?

[FJCC]

This code protects the sheet called Sheet1 without asking for a password.

Code: Select all

oSheets = ThisComponent.Sheets
oSheet = oSheets.getByName("Sheet1")
oSheet.protect("")

If you have trouble integrating that into your code, please post your code so we can make suggestions.

[DBGarfield]

Thank you; this works fine.