aziz rasul
Active member
- Local time
- Today, 06:13
- Joined
- Jun 26, 2000
- Messages
- 1,935
I have the following snippet of code
and
I get no errors but the file opens without prompting me with a password!
Code:
objExcelAppOriginal.ActiveWorkbook.Sheets(strWorksheet).Protect Password:=strPassword, DrawingObjects:=True, Contents:=True, Scenarios:=True, AllowFormattingCells:=True, AllowFormattingColumns:=True, AllowFiltering:=True
and
Code:
With objExcelAppOriginal
.ActiveWorkbook
.Protect Password:=strPassword, Structure:=True, Windows:=False
.Save
.Close
End With
I get no errors but the file opens without prompting me with a password!