Make excel workbook readonly

Hi all,

I am doing some excel automation from my windows application. From the code, I open an Excel Workbook, write into it, and then close it while saving it. Is it possible to make this file or workbook readonly It should be strictly readonly and nobody should be able to modify it, even by doing a right click and unchecking the Read Only checkbox from the Properties.

This is what I tried but didnt work:

Hi,

What about protecting every sheet in the workbook Code looks like:

app.Workbooks.Open(@"C:\test.xlsx", missing, missing, missing, missing, missing,

missing, missing, missing, missing, missing, missing, missing, missing, missing);

int count = app.Worksheets.Count;

for (int i = 1; i <= count;i++ )

{

Excel.Worksheet ws = app.Worksheets as Excel.Worksheet;

ws.Protect("851230",missing,missing,missing,missing,missing,missing,

missing,missing,missing,missing,missing,missing,missing,missing,

missing);

}

Hope it helps!

Thanks

Ji

Thanks Ji,

That certainly is a solution and I kinda figured that out while I was playing with my code. Instead of looping thru all the sheets, since I had only three sheets and was working on them at different points and modules, I password protected each of them seperately and it seems to work.

I tried password protecting the whole workbook but that didn't work. Do you know why

Thanks so much...

bullpit

Thanks for that clarification. I really appreciate all your help. Is there a way to strongly protect the sheets so no one can modify them instead of having sheets password protected Password protection is very basic (I know its not meant to make sheets unmodifiable) and is easy to break.

Any pointers on this

Thanks again,

bullpit