Search code examples
securityexcelvbavbscriptxls

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

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

Solution

  • 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.