(I am using Lotus Notes 8.5)
Currently I have code that takes data/information and exports it to an excel spreadsheet. That all works fine. What I want to do now is add protection to the code so that the users are not able to change the data in the spreadsheet once it is created. I of course have to write the code in lotusscript. This is the code I have right now:
Const xlNoSelection = -4142
Set xlCell = xlSheet.Range (“A1:AN30”)
xlCell.Select.Selection.Locked = True
xlCell.Select.Selection.FormulaHidden = True
xlCell.Protect.DrawingObjects = True
xlCell.Protect.Contents = True
xlCell.Protect.Scenarios = True
xlCell.EnableSelection = xlNoSelection
What am I doing wrong? What is the correct way to write this in lotusscript for it to work?
Thanks in advance.