Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to merge separate worksheet | Excel Worksheet Functions | |||
Using a Worksheet Form to add data to a separate worksheet databas | Excel Worksheet Functions | |||
How do I separate a worksheet into many files? | Excel Discussion (Misc queries) | |||
Separate Worksheet Linking | Excel Discussion (Misc queries) | |||
userforms and worksheet help | Excel Programming |