Excel Worksheet Protection using Lotusscript

HCL Notes/Domino 8.5 Forum (includes Notes Traveler)

Subject: Excel Worksheet Protection using Lotusscript

Feedback Type: Question

Product Area: Domino Server

Technical Area: Functionality

Platform: Windows

Release: 8.5.2

Reproducible: -Reproducibility-

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.

Feedback number WEBB8FELQS created by ~Evelyn Fezboosichekobu on 03/29/2011

Status: Open
Comments: