You can set the options in Tools=>Customize=>Options
=====
How do I turn off the default setting for expanding dropdown boxes so that
the menu listings are all displayed?>>
--
Let us know if this helped you,
Bob Buckland ?
MS Office System Products MVP
*Courtesy is not expensive and can pay big dividends*