Userforms
 

I have placed a button on the standard tool bar that will access a userform
in another spreadsheet located in a network folder. The goal is to place this
button on the users tool bar for quick access.

Eddie

Userforms
 

Good afternoon Eddie

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

HTH

Dominic

--
dominic
-----------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...fo&userid=1893
View this thread: http://www.excelforum.com/showthread.php?threadid=39951

Userforms
 

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

Userforms
 

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

Userforms
 

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

Userforms
 

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