title: Excel (VBA): Disabling cell formatting except bold font
body: <p>I'd like to disable changing the format of the cell except making font bold. Is there any way to achieve that?</p>
  
  <p>Obviously, 
  <code>.Protect AllowFormattingCells:=True</code> enables all possible format changes.</p>
  
  <p>I've thought that maybe making custom button on Ribbon could serve for this (i.e. unprotecting sheet, making the content bold and protecting again), but I wonder whether there is some more convenient approach to this problem.</p>
  
  <p>I've come across similar issue at <a href="http://www.excelforum.com/excel-programming-vba-macros/676299-use-vba-to-lock-all-cell-formatting-except-background-color.html" rel="nofollow">http://www.excelforum.com/excel-programming-vba-macros/676299-use-vba-to-lock-all-cell-formatting-except-background-color.html</a> - but it also remains unsolved.</p>