Color pallet

[camlad]

A XL2003 macro, written for a visually handicapped friend, which toggled the
font and fill color pallets does not work in XL2007
Please tell me what is the 2007 equivalent of
Application.CommandBars("Font Color").Visible = True
(I do not have 2007 installed at home and will have only a short time to
edit his macro when I call next.
Many thanks
Camlad

 

[camlad]

Thanks Jan for asking. I have built a calendar for him in which he, as
secretary of a large charitable organisation, enters many and varied meeting
dates. It opens at today's date and has many buttons to simplify his use
including a toggle to show/hide unoccupied dates. It has been the most used
and valuable item on his computer for about 4 years since failing eyesight
lead to his retirement without any computer skills at all.



Many of the varied meetings are entered by means of one of a series of
colour coordinated buttons, each of which call a macro to enter the meeting
and make the fill and font colours distinctive and so the different types of
meeting are readily seen. Occasionally he enters a non-standard meeting and
so there is a button which toggles true/false the font and fill pallets for
easy use.



It is not a great problem for him to change the colours but going to the
menu but I should like to have reinstated this feature.



Now that 2008 does not support VBA I can no longer write macros on the large
Mac screen without Parallels or similar running 2003 - I shall wait for 2011
or whatever/whenever, trusting that VBA is resurrected. and for now stick
with 2003 on this tiny mini laptop screen. As for my friend I shall have to
customise the bloated menus of 2007 so he has maximum screen for his minimal
vision - font and fill colors are buttons I would have missed out.



I am grateful for your interest.



Camlad

 

[camlad]

Thank you very much Jan - I shall see him next Monday and the tips you have
given will certainly be useful while we get to grips with 2007.

With best wishes,

Camlad