LOAD userform

[JohnTheTemp]

OS: Windows 2000
App: Excel 2000

I have a userform in my Personal Macro Workbook called "frmPunchlistEntry"
and generally the macro below works fine. I just can't figure out why fails
to load with an "Application-defined or object-defined error" at the "Load"
statement.

Sub PunchlistEntry()
Load frmPunchlistEntry
frmPunchlistEntry.Show
End Sub

Any ideas? Thanks.

--
JohnTheTemp

[JohnTheTemp]

Well...I discovered that I get the same error when activating the userform
from the VB Editor. So the problem isn't with "Load".

There's something about the workbook I currently have open. The userform
works fine with another workbook.

--
JohnTheTemp


"JohnTheTemp" wrote:

> OS: Windows 2000
> App: Excel 2000
>
> I have a userform in my Personal Macro Workbook called "frmPunchlistEntry"
> and generally the macro below works fine. I just can't figure out why fails
> to load with an "Application-defined or object-defined error" at the "Load"
> statement.
>
> Sub PunchlistEntry()
> Load frmPunchlistEntry
> frmPunchlistEntry.Show
> End Sub
>
> Any ideas? Thanks.
>
> --
> JohnTheTemp

[JohnTheTemp]

The problem turned out to be Range Names which were accessed by the
macros--but they weren't used in the newer spreadsheet.