View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Murray[_3_] Murray[_3_] is offline
external usenet poster
 
Posts: 3
Default Format the command for the Currency button

In Excel 2003, there was a way to change the commands linked to a button. So for instance, I like making my negative numbers red, so I reformatted the Currency button to make all the negative numbers red.

I now have 2007 and I am battling. I have found a way to edit the Currency button but it does not keep the setting if I close Excel.

Please can somebody advise how I can make this permanent

Thanks
Murray