Protecting Workbooks and Worksheets

Hi,

I'm trying to protect a workbook and it's worksheets. There does not seem to be an option .protect like in VB or VBA. There is an option .Locked but this does not protect the workbook or worksheets. Would anyone know how this can be done?

Thanks,

Dee. 

 

Hi Dee,

try to lock not only the cells, but also the XLSheet.

From the doc to XLSheet.Locked:

"Sheets and styles can be locked. By default, sheets are unlocked and styles are
locked. This combination allows users to edit the cells in Excel.

To protect a cell against editing in Excel, both the sheet and the cell style
must have the Locked property set to true.

To lock most cells on a sheet and allow editing of only a few cells, lock the
sheet, then create an unlocked style and assign it to the cells that should be
editable."

Hope this helps

Wolfgang

Thanks Wolfgang, that works.

 Dee.

Hi Wolfgang,

Is there any way of protecting the worksheets with passwords?

 Thanks,
Dee.

Hi Dee,

I am quite sure that C1Excel does not support this.

Best regards

Wolfgang