Yes, the workbook could be hidden. Of course, the procedure that
shows the userform must be in the hidden workbook. You can't
directly access a userform in another workbook, hidden or not.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Eddie" wrote in message
...
Could I hide the workbook?

"Chip Pearson" wrote:

You can't. The workbook needs to be open.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Eddie" wrote in message
...
They problem is how do I call a Userform in a different
workbook, but not
have that workbook open?

Eddie

"dominicb" wrote:


Good afternoon Eddie

Right click on a toolbar and select customize.
From the commands tab drag an icon (any icon) onto the
toolbar
you want
to add it to.
Then right click your new icon, give it a name, give it a
trendy image
(or draw your own) and assign your macro.
Done.

HTH

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile:
http://www.excelforum.com/member.php...o&userid=18932
View this thread:
http://www.excelforum.com/showthread...hreadid=399512