LOAD userform
 

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

LOAD userform
 

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

LOAD userform
 

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