AC PORTA VIA
Board Regular
- Joined
- Apr 9, 2016
- Messages
- 235
- Office Version
- 365
- Platform
- Windows
If I am using line #1 below to add password to open than I can use line #2 for password to modify
why can't I use just line to add password to modify without password to open?
'line1 password to open
'line#2 password to modify
why can't I use just line to add password to modify without password to open?
'line1 password to open
VBA Code:
.Password = Workbooks("MY WORKBOOK.xlsm").Sheets("TEST").Cells(I, 6).Value
'line#2 password to modify
Code:
.Protect Password:=Workbooks("MY WORKBOOK.xlsm").Sheets("TEST").Cells(I, 7).Value