Skip to Content
0
Mar 20, 2009 at 11:50 PM

Make few columns of Excel file read only when downloaded

817 Views

Hi Experts,

Is there any way we can set few of the columns in excel sheet as read only when downloaded from SAP.

We have requirement where a program will generate a report and download it into an excel file on desktop. When the file is downloaded, two of its columns should be non editable.

I know complete sheet of excel can be protected using OLE, can we protect few columns also using OLE?

any idea how can it be done?