This is odd.

I ran the code, and as you say, I get the error.

If I then access the forms properties in the watch window, I can then run
the code fine. Change the property, and it won't run again.

No answers, yet, but I will dig around.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"VJ" wrote in message
...
Can somebody suggest me why I am getting "Unspecified Error" when the
following line of code executes.

Debug.Print

Application.Workbooks("WBName.xlt").VBProject.VBCo mponents.Item("FormName").
Properties.Item("ShowModal").Value

Before opening the workbook, I am unlocking it which is working fine but
for
some reason I am not able to get reference to the Properties collection.
It
works fine sometimes when I run in the debug mode.

Help would be appreciated.

Thanks,