Full range of colours from the toolbar

JW · Mar 20th, 2002, 02:49 AM

Hi,
The toolbar has 40 colours for fills and fonts, but there are another 8 via Format
Cells - as I've started to use 3 of these semi regularly, is there a way to import these to the toolbar, or have the toolbar show the full range? (btw Running Excel 97 here)
Thanks

Dave Hawley · Mar 20th, 2002, 03:09 AM

Hi JW

Try right clicking on any toolbar then select "Customize", select the Commands Tab and click "Format" have a scroll through and drag some options onto your toolbar.

JW · Mar 20th, 2002, 05:04 AM

Unless I'm missing something, all of the custom fill and font options are for the 40 colour set, not 48. I could easily set up some individual macros but it would be much easier if the full Fill and Fontcolour range was available on the toolbar - is there any
kind of 'Show All Colours' VBA script to link to a macro toolbutton?

Dave Hawley · Mar 20th, 2002, 05:20 AM

Assign these:

Sub FontForm
Application.Dialogs(xlDialogFontProperties).Show
End sub

Sub Pattern()

Application.Dialogs(xlDialogPatterns).Show
End Sub

JW · Mar 20th, 2002, 06:06 AM

Thanks Dave

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 20th, 2002, 02:49 AM	#1
JW Board Regular Join Date: Mar 2002 Posts: 72	Hi, The toolbar has 40 colours for fills and fonts, but there are another 8 via Format Cells - as I've started to use 3 of these semi regularly, is there a way to import these to the toolbar, or have the toolbar show the full range? (btw Running Excel 97 here) Thanks

Mar 20th, 2002, 03:09 AM	#2
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hi JW Try right clicking on any toolbar then select "Customize", select the Commands Tab and click "Format" have a scroll through and drag some options onto your toolbar.

Mar 20th, 2002, 05:04 AM	#3
JW Board Regular Join Date: Mar 2002 Posts: 72	Unless I'm missing something, all of the custom fill and font options are for the 40 colour set, not 48. I could easily set up some individual macros but it would be much easier if the full Fill and Fontcolour range was available on the toolbar - is there any kind of 'Show All Colours' VBA script to link to a macro toolbutton?

Mar 20th, 2002, 05:20 AM	#4
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Assign these: Sub FontForm Application.Dialogs(xlDialogFontProperties).Show End sub Sub Pattern() Application.Dialogs(xlDialogPatterns).Show End Sub

Mar 20th, 2002, 06:06 AM	#5
JW Board Regular Join Date: Mar 2002 Posts: 72	Thanks Dave