excel protect method

S

Scott

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 signature:

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
 
T

Tom Ogilvy

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.
 
S

Scott

Thanks Tom, that seems to be the case.

Does anyone know of a way - with this version of the protect method that I
can specify that the format of the rows and columns of the spreadsheet can be
formated?

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top