ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Buttons with symbols (https://www.excelbanter.com/excel-programming/298929-buttons-symbols.html)

Kevin

Buttons with symbols
 
Hi, i have a table of contents and i want it to be expandable or contractable via a macro when you click a button. essentially it is hiding rows but i prefer it to the grouping function. my question is, is there a way can have a plus sign and a minus sign on the buttons

thanks

Bob Phillips[_6_]

Buttons with symbols
 
You could just change the command button caption to + and -, but they will
be a bit big. You could also get Plus and Minus icons off of the web, and
use a picture and assign your macro to them.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"kevin" wrote in message
...
Hi, i have a table of contents and i want it to be expandable or

contractable via a macro when you click a button. essentially it is hiding
rows but i prefer it to the grouping function. my question is, is there a
way can have a plus sign and a minus sign on the buttons?

thanks





All times are GMT +1. The time now is 07:00 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com