View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
PF[_3_] PF[_3_] is offline
external usenet poster
 
Posts: 2
Default Unable to set Underline property of the Font class

The solution was unprotecting the worksheet before changing the underline property. Excel 2003 has a new way of locking cells, and the cell was locked both from changing the content and changing the format. A different way of fixing it is to just lock the cells from changes in the GUI, which allows changes to still be made from the code.