P
Patrick C. Simonds
Had to reformat my hard drive and reinstall Excel (2007) and now when I run
one of my spreadsheets I get the following error:
Can Not Find Project or Libary
When I checked for missing referances, DHTML Edit Control for IE5 was
missing.
The w in the line "For Each w In ThisWorkbook.Worksheets" was
highlighted.
Sub unprotect_all_sheets()
Application.ScreenUpdating = False
For Each w In ThisWorkbook.Worksheets
w.Unprotect Password:="popcorn"
Next
Application.ScreenUpdating = True
End Sub
one of my spreadsheets I get the following error:
Can Not Find Project or Libary
When I checked for missing referances, DHTML Edit Control for IE5 was
missing.
The w in the line "For Each w In ThisWorkbook.Worksheets" was
highlighted.
Sub unprotect_all_sheets()
Application.ScreenUpdating = False
For Each w In ThisWorkbook.Worksheets
w.Unprotect Password:="popcorn"
Next
Application.ScreenUpdating = True
End Sub