View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default excel protect method

That is the argument list for xl2000 and earlier. Perhaps you are not using
the correct interop. I don't use C# or VB.Net, so I can't say for sure.

--
Regards,
Tom Ogilvy

"Scott" wrote in message
...
Hi,

I'm developing an application that populates a spreadsheet from a C# app.

After the data has been inserted into the spreadsheet I want to protect

all
but one column - this I can do. However I want to allow the user to format
all of the rows and columns.

It appears the protect method I have available through the _worksheet
interface isn't the one that appears in all the documentation I can find

and
therefore I have a reduced set of functionality.

The protect method I have access to is of the following signatu

public abstract new void Protect ( System.Object Password , System.Object
DrawingObjects , System.Object Contents , System.Object Scenarios ,
System.Object UserInterfaceOnly )

However the one that I can find in the documentation and gives more

control
over the spreadshet has 16 parameters!

I'm using Visual Studio 2003, the Excel namespace in my code and I have
Excell 2002 installed.

Your help is very much appreciated.

Thanks