View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dontgue dontgue is offline
external usenet poster
 
Posts: 3
Default change the default worksheet to always format formulas blue?

Does this apply to Excel 2007? I can't find the Personal.xls file.
--
dontgue


"Gord Dibben" wrote:

Only if you place the code into Personal.xls or an add-in.

Then you simply add a button to a Toolbar and assign the macro to that
button.


Gord Dibben MS Excel MVP

On Wed, 2 Sep 2009 15:22:01 -0700, dontgue
wrote:

I am referring to the font for the value displayed by the formula. Thanks
for the macro. Can I create a button that will be available in all opened
files?