Hello,
When i protect a cell of a sheet and activate the protection, the cell is pretected but i can't change
the colors or size of other cells .
How to enable it ?
Thanks .
Here is the code :
oxls := TOleAuto():New("Excel.Application")
oxls:WorkBooks:Open("test.XLS")
oBook := oxls:Get( "ActiveWorkBook")
oSheet := oxls:Get( "ActiveSheet" )
oxls:Sheets("Actif"):select()
oxls:visible:=.T.
oSheet := oxls:Get( "ActiveSheet" )
oSheet:UnProtect("TEST")
oSheet:Range("A1","IV600"):Locked:=.F.
oSheet:Cells( 6, 2 ):Select()
oSheet:Cells( 6, 2 ):Font:Size := 7
oSheet:Cells( 6, 2 ):WrapText := .T.
wtxtp:="Something to be protected "
oSheet:Cells( 6, 2 ):Value:=wtxtp
oSheet:Cells( 6, 2 ):Locked := .T.
*
oSheet:Protect("TEST")
*
OLE XLS
Return to “FiveWin for Harbour/xHarbour”
Jump to
- English Forums
- ↳ FiveWin for CA-Clipper
- ↳ FiveWin for Harbour/xHarbour
- ↳ FiveTouch
- ↳ EasyReport, EasyDialog and EasyPreview
- ↳ FiveMac / FivePhone (iPhone, iPad)
- ↳ FiveLinux / FiveDroid (Android)
- ↳ FiveWin for Pocket PC
- ↳ mod_harbour
- Foros en Español
- ↳ FiveWin para CA-Clipper
- ↳ FiveWin para Harbour/xHarbour
- ↳ FiveTouch
- ↳ EasyReport, EasyDialog y EasyPreview
- ↳ FiveMac / FivePhone (iPhone, iPad)
- ↳ FiveLinux / FiveDroid (Android)
- ↳ FiveWin para Pocket PC
- ↳ mod_harbour
- Forum italiani
- ↳ All products support
- Forum Portuguese
- ↳ All products support
- Forum German
- ↳ All products support
- General
- ↳ WhatsNew / Novedades
- ↳ Bugs report & fixes / Informe de errores y arreglos
- ↳ To do - WishList / Por hacer - Peticiones
- ↳ Utilities / Utilidades
- ↳ Off Topic / Otros temas
- Artificial Intelligence
- ↳ TensorFlow and Python examples
- ↳ TensorFlow.dll for Harbour and FWH
- ↳ latest AI news
- ↳ Building TensorFlow.dll
- ↳ AI Introduction (Harbour code and samples)