Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I created and used the following code in Excel 2000 with
no problems: Private Sub Workbook_Open() If Worksheets("BudgetForm").Protect = False Then Worksheets("BudgetForm").Range("g16:g19").Locked = False Worksheets("BudgetForm").Range("h16:h19").Locked = False Worksheets("BudgetForm").Range("h25:h29").Locked = False Worksheets("BudgetForm").Range("g31:g47").Locked = False Worksheets("BudgetForm").Protect Contents:=True, Objects:=True, Scenarios:=True End If ActiveWorkbook.Protect Structu=True, Windows:=False Range("A1").Select End Sub But since I have upgraded to Excel 2002, I get an error message when opening the workbook. The highlighted code is the second line. Any help is appreciated! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Protect sheet unchecking "Select locked cells" has undesiredresults | Excel Discussion (Misc queries) | |||
protect formulas in locked cells from changing if data is moved | Excel Discussion (Misc queries) | |||
Macros to protect worksheet and prevent locked cell selection | Excel Discussion (Misc queries) | |||
Locked cells with Protect Sheet. | Excel Discussion (Misc queries) | |||
Workbook_Open not working | Excel Discussion (Misc queries) |