View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Patrick C. Simonds Patrick C. Simonds is offline
external usenet poster
 
Posts: 343
Default Project / Libary error

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