Replied 8 September 2017, 1:36 pm EST
I am using an Excel template. The editable cells are unlocked, the non-editable ones locked. I load this template from the disk, then set protection = true in the code. At that point, all the cells in the workbook are non-editable.
I am setting the cursor type with the following code:
The EditModeReplace is set to true.
I have a status bar on the form that contains the spreadsheet to show the user whether the cell is locked or not. That display is controlled in the 'enter_cell' event:
If Me.FpSpread1.Sheets(1).Cells(e.Row, e.Column).Locked Then
Me.BarStaticItem12.Caption = "Locked"
Me.BarStaticItem12.Caption = ""
When the application runs, the status correctly shows whether the cell is locked or not. I cannot edit any of the cells that are not displayed as locked in the status bar. But the cursor always remains as the windows.no
Here is the funny part: I have an executable on my development machine that is compiled with version 2.5 Spread. It has been working fine as a demo app. Now that version 4.0 is on the workstation, the executable exhibits the same problem.