excel protect method
 

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

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

excel protect method
 

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

"Tom Ogilvy" wrote:

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