Start UserForm From Different Workbook
Application.Run "'fileName.xls'!ShowForm"
Where ShowForm is a routine in a normal module in the other workbook that
show's the form.
Depending on fileName.xls you might need to embrace it with apostrophes, no
harm to include them
Regards,
Peter T
"Minitman" wrote in message
...
Greeting,
I have a UserForm in one workbook that I need to open from a
CommandButton in another workbook. I don't know the syntax to put in
that CommandButton's code to accomplish this.
Anyone know how to do this?
Any help would be greatly appreciated.
-Minitman
|