Awesome, thank you!
On 05/28/20 1:46 AM, lists via 4D_Tech wrote:
Ken, You build the format and assign the different attributes to it (one of which can be the locked flag, a font etc). $ YourDefinedFormat:=xlBookAddFormat ($xlBook) $font:=xlBookAddFont ($xlBook) xlFormatSetFont ($YourDefinedFormat;$font) xlFontSetName ($font;"Arial") xlFontSetSize ($font;10) xlFormatSetLocked( $YourDefinedFormat; 1 ) Then, when you assign a cell value, you also assign the format as in: xlSheetSetCellNumber ($sheet;$row;$col;$cellData;$YourDefinedFormat) HTH Lahav
********************************************************************** 4D Internet Users Group (4D iNUG) New Forum: https://discuss.4D.com Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **********************************************************************