Change Empty Cells Font for the Entire Workbook
Hi Norman,
I realise that I managed, inexcusably, to miss the
important statement:
That's a bit self critical. I tend to congratulate myself
if I interpret something right way first time :-)
Regards,
Peter
-----Original Message-----
Hi Peter,
Re-reading Paul's original post in the light of your
response, I realise
that I managed, inexcusably, to miss the important
statement:
All the Cells in the Spreadsheet ( and Workbook ) that
have
Information and Formulas in are Either "Tahoma"
or "Comic Sans MS"
Font.
Taking this into account, Tom's advice to change the
style to Tahoma has to
be the solution of choice whether the implementation be
manual or
programmatic.
One thing though, if the "Normal" font is still set to
Arial, if a user subsequently clears formats the font
will
revert to Arial.
As this does not appear to be something that the user
could achieve
inadvertently, I doubt that it should cause the OP any
anxiety.
---
Regards,
Norman
Snip
|