ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Project / Libary error (https://www.excelbanter.com/excel-programming/429673-project-libary-error.html)

Patrick C. Simonds

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



All times are GMT +1. The time now is 03:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com