Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Changing Border buttons on the toolbar

Is it possible to change the default buttons that appear in the Border
drop-down box/Border floating menu?

There are some default buttons I've never used, such as the double line on
the bottom with the single line on the top.

I'd like to be able to remove these buttons I never use and replace them
with buttons for borders that I use a lot, such as diagonal lines running
from corner to corner forming an X though the cell.

Or maybe just to change the weight of the line that makes up the border
without having to right-click, select borders, redraw the border, and then go
back to the worksheet.

Is it possible to do this so my custom borders can be placed into the Border
Menu/Drop-down Box?

Oh, BTW, it seems I can add certain single lines to the menu using Tools
Customize Commands, but those lines each have to be drawn individually and
they don't appear in the "Auto border button" next to the drop-down arrow.

Any easy fixes?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 103
Default Changing Border buttons on the toolbar

Fozzie Bear;

I don't know if what you are trying to do is possible, but you can place any
button you want onto the toolbar. Right click on a blank toolbar area and
select CustomizeCommand TabFormat. You may have to scroll down a bit to get
to what your looking for. If you draw a lot of borders, add the border
toolbar. This lets you place what you want where you want it.

God Bless

Frank Pytel

"Fozzie Bear" wrote:

Is it possible to change the default buttons that appear in the Border
drop-down box/Border floating menu?

There are some default buttons I've never used, such as the double line on
the bottom with the single line on the top.

I'd like to be able to remove these buttons I never use and replace them
with buttons for borders that I use a lot, such as diagonal lines running
from corner to corner forming an X though the cell.

Or maybe just to change the weight of the line that makes up the border
without having to right-click, select borders, redraw the border, and then go
back to the worksheet.

Is it possible to do this so my custom borders can be placed into the Border
Menu/Drop-down Box?

Oh, BTW, it seems I can add certain single lines to the menu using Tools
Customize Commands, but those lines each have to be drawn individually and
they don't appear in the "Auto border button" next to the drop-down arrow.

Any easy fixes?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Bottom Double Border in Toolbar- Excel 2003 F W Green Excel Discussion (Misc queries) 2 August 11th 07 02:38 PM
Bottom double border from toolbar-customize format not working Tab Excel Discussion (Misc queries) 1 August 16th 06 10:05 PM
Toolbar buttons Liz Excel Discussion (Misc queries) 6 January 23rd 06 01:10 PM
Changing the border of one cell s/n change the border of adjacent gjanssenmn Excel Discussion (Misc queries) 2 October 5th 05 09:35 PM
Toolbar Buttons bmac Excel Discussion (Misc queries) 2 March 9th 05 12:05 AM


All times are GMT +1. The time now is 05:24 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"