Search found 4 matches

by stevef199
Tue Jan 28, 2014 3:52 pm
Forum: XLSReadWritwII 6
Topic: How to turn on Workbook protection?
Replies: 3
Views: 2793

Re: How to turn on Workbook protection?

In Excel the menu command is: Review->Protect Workbook (Protect Workbook for: o Structure o Windows)
by stevef199
Sun Jan 26, 2014 9:00 pm
Forum: XLSReadWritwII 6
Topic: How to turn on Workbook protection?
Replies: 3
Views: 2793

How to turn on Workbook protection?

How to turn on Workbook protection?
by stevef199
Sat Jan 25, 2014 3:12 am
Forum: XLSReadWritwII 6
Topic: How to hide a worksheet?
Replies: 1
Views: 1671

How to hide a worksheet?

How to hide a worksheet?
by stevef199
Sun Jan 19, 2014 11:37 am
Forum: XLSReadWritwII 6
Topic: Lookup lists
Replies: 1
Views: 1738

Lookup lists

I've got some code to implement lookup lists, but either its not complete or not correct: My code: dv := xlsreadwrite.Sheets[0].Validations.Add; with dv do begin Formula1 := '$R$275:$R$276'; Sqref.Add(0, 0); ShowDropDown := True; Type_ := x12dvtList; AllowBlank := False; end; This code correctly put...