Userforms in a separate worksheet
 

I am trying to centralize all my macro functions. We have 35 or so users
all using the same macros, so I've created one file they all draw on. Is it
possible to do this with Userforms as well? I'm getting an "error 424 -
Object required". The code reads: "Load mastermacro.xls!UserForm1"
Mastermacro is the filename I've used for my main macro file. The macros run
just dandy, but the userforms won't load. Any suggestions? Any help would
be appreciated.

--
Thanks - Paula

Userforms in a separate worksheet
 

I don't believe you can do it directly. You can run a macro in the
other workbook that loads the form with the following:

Application.Run "OtherWookbookName!MacroThatLoadsForm"

Hth,
Merjet

Userforms in a separate worksheet
 

I think Merjet is correct. I struck this problem recently. I had to
do an export and a re-import of the form, but that doesn't sound like
the fix you need.

Good luck.

Greg