Hi I made the changes in my project & it worked perfectly.

when I put the VBA Project password to hide coding execution gives me error

Run-Time error '50289'
Can't perform operation since the project is protected


error comes in this line

[VBA]Dim Shtnm21, shtnm26, shtnm25 As String
With ActiveWorkbook.VBProject
Shtnm21 = CStr(.VBComponents("Sheet21").Properties("Name")) 'Declared as Dividend
shtnm26 = CStr(.VBComponents("Sheet26").Properties("Name")) 'Delcared as PreBhav-Fut
shtnm25 = CStr(.VBComponents("Sheet25").Properties("Name")) 'Delcared as CurBhav-Fut

End With[/VBA]

if I am taking through XLD given code it works perfectly in open source code project. but the moment I lock the project it gives error

so there is any code which unlock my VBA project & then lock it after completion of code.

I am having code its my own working (means I am not asking for code breaking)


pl help