Userforms

[Eddie]

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
[email protected]

[dominicb]

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

[Eddie]

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
>
>

[Chip Pearson]

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


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


"Eddie" <[email protected]> wrote in message
news:[email protected]...
> 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
>>
>>

[Eddie]

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" <[email protected]> wrote in message
> news:[email protected]...
> > 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
> >>
> >>
>
>
>

[Chip Pearson]

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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
>> news:[email protected]...
>> > 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
>> >>
>> >>
>>
>>
>>