"50289 Can't perform operation since the project is protected" but why?

Question

I am supplying the correct password

Set objExcel = CreateObject("Excel.Application")
Set objWorkbook = objExcel.Workbooks.Open("H:\M\X\C.xls", 0, , , "password")

'any of these lines cause the error mentioned

Set vbcomp = objWorkbook.VBProject.VBComponents(modname)
objWorkbook.VBProject.VBComponents.Remove vbcomp
objWorkbook.VBProject.VBComponents.Import modpath & modtest

Any ideas what the problem might be? Tools-Macro-Security is set to allow VB project access

Answer 1

The VBA project itself is protected by a password which is different then the worksheet password. Open the VBA IDE - select Tools-VBA Project Properties and look at the Protection Tab.

Not sure how or if you can remove the VBA Project password using code.

Answer 2

This may sound extreme, however I managed to get around this by downloading Windows Installer Clean up Utility (look for msicuu2.exe in Google) and removed office 2003. I then reinstalled office 2003 and my problem had disappeared. Hope it solves your probelm too. Alex