B
bw
When I open the workbook, Sheet CALCULATEHERE is not protected properly.
"Select locked cells" and Select unlocked cells" are both checked. Can
someone explain what I'm doing wrong?
Thanks,
Bernie
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Sheets("CALCULATEHERE").Select
UNPROTECTSHEET
Range("A1") = 0
Range("A2") = 0
Range("A4").Select
DELETEWORKSHEETS
Sheets("CALCULATEHERE").Select
PROTECTSHEET
'When I check the sheet here, it is protected properly, but something
apparently goes wrong on the next line. ActiveWorkbook.Save
End Sub
Sub PROTECTSHEET()
ActiveSheet.Protect DrawingObjects:=True, Contents:=True,
Scenarios:=True
ActiveSheet.EnableSelection = xlUnlockedCells
End Sub
"Select locked cells" and Select unlocked cells" are both checked. Can
someone explain what I'm doing wrong?
Thanks,
Bernie
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Sheets("CALCULATEHERE").Select
UNPROTECTSHEET
Range("A1") = 0
Range("A2") = 0
Range("A4").Select
DELETEWORKSHEETS
Sheets("CALCULATEHERE").Select
PROTECTSHEET
'When I check the sheet here, it is protected properly, but something
apparently goes wrong on the next line. ActiveWorkbook.Save
End Sub
Sub PROTECTSHEET()
ActiveSheet.Protect DrawingObjects:=True, Contents:=True,
Scenarios:=True
ActiveSheet.EnableSelection = xlUnlockedCells
End Sub