> 1. I have a current userform but the only way to show it is to go into
> tools/macros etc, I want to put a command button on the page to show
> this userform but I don't want the button to print.
> Any ideas.

> 2. How do I sort an add item list alphabetically.

> Thanks for any help (sorry about the x post)

> Cheers
> Jill

> First, you might get better results posting this in the vba.userforms
> newsgroup. I would suggest two posts, one with a subject of "sort add item
> list" and the other being "non-printing button needed."

> For the non-printing button, consider a custom toolbar with a macro that
> displays your form. You may also want to take a look at <URL:
> http://www.mvps.org/word/FAQs/TblsFldsFms/HidePrintButton.htm>.

> Don't know about sorting. You may want to see if you can find something
> through <URL: http://www.mvps.org/word/FAQs/Userforms.htm>.

> Hope this helps,
> --
> Charles Kenyon

> Word New User FAQ & Web Directory:
> <URL: http://www.addbalance.com/word/index.htm>

> Intermediate User's Guide to Microsoft Word (supplemented version of
> Microsoft's Legal Users' Guide)
> <URL: http://www.addbalance.com/usersguide/index.htm>

> See also the MVP FAQ: <URL: http://www.mvps.org/word/> which is awesome!
>  --------- --------- --------- --------- --------- ---------
> This message is posted to a newsgroup. Please post replies
> and questions to the newsgroup so that others can learn
> from my ignorance and your wisdom.

> > Hi all
> > I have two questions regarding userfoms

> > 1. I have a current userform but the only way to show it is to go into
> > tools/macros etc, I want to put a command button on the page to show
> > this userform but I don't want the button to print.
> > Any ideas.

> > 2. How do I sort an add item list alphabetically.

> > Thanks for any help (sorry about the x post)

> > Cheers
> > Jill

> I started to reply in a similar vein, Charles, then looked at the header
and
> hit the X!

> --
> Suzanne S. Barnhill
> Microsoft Word MVP
> Words into Type
> Fairhope, AL USA

> > Hi Jill,

> > First, you might get better results posting this in the vba.userforms
> > newsgroup. I would suggest two posts, one with a subject of "sort add
item
> > list" and the other being "non-printing button needed."

> > For the non-printing button, consider a custom toolbar with a macro that
> > displays your form. You may also want to take a look at <URL:
> > http://www.mvps.org/word/FAQs/TblsFldsFms/HidePrintButton.htm>.

> > Don't know about sorting. You may want to see if you can find something
> > through <URL: http://www.mvps.org/word/FAQs/Userforms.htm>.

> > Hope this helps,
> > --
> > Charles Kenyon

> > Word New User FAQ & Web Directory:
> > <URL: http://www.addbalance.com/word/index.htm>

> > Intermediate User's Guide to Microsoft Word (supplemented version of
> > Microsoft's Legal Users' Guide)
> > <URL: http://www.addbalance.com/usersguide/index.htm>

> > See also the MVP FAQ: <URL: http://www.mvps.org/word/> which is awesome!
> >  --------- --------- --------- --------- --------- ---------
> > This message is posted to a newsgroup. Please post replies
> > and questions to the newsgroup so that others can learn
> > from my ignorance and your wisdom.

> > > Hi all
> > > I have two questions regarding userfoms

> > > 1. I have a current userform but the only way to show it is to go into
> > > tools/macros etc, I want to put a command button on the page to show
> > > this userform but I don't want the button to print.
> > > Any ideas.

> > > 2. How do I sort an add item list alphabetically.

> > > Thanks for any help (sorry about the x post)

> > > Cheers
> > > Jill

> 1. I have a current userform but the only way to show it is to go into
> tools/macros etc, I want to put a command button on the page to show
> this userform but I don't want the button to print.
> Any ideas.

> 2. How do I sort an add item list alphabetically.