I am working on a SAS DDE program to write multiple sheets to excel. I would like to make one of the sheet readonly. If I cannot make the sheet readonly, atleast i would liek to make some cells readonly, so thta user cannot update the value isn these cells.
I found this code form the internet, but it is not working:
put '[select("sheet1!c1:c20")]'; /* select first 20 columns */
put '[CELL.PROTECTION(true, false)]'; /* lock cells */
Any help is appreciated.
I found this code form the internet, but it is not working:
put '[select("sheet1!c1:c20")]'; /* select first 20 columns */
put '[CELL.PROTECTION(true, false)]'; /* lock cells */
Any help is appreciated.