![]() |
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