.Net and Excel 2000 Protect

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to use the protect feature for a worksheet in 2000 from a .Net
application I am writing. I can unprotect it. But can not protect worksheet.
I can protect and unproject in Excel 2003. Does anyone have the proper
command structure for 2000. Help files were vague at best.

Thanks
 
This works fine for me with Excel 2000/XP/2003

ws.Protect("",missing,missing,missing,true,true,true,true,false,false,missin
g,false,false,missing,missing,missing);

where missing = System.Reflection.Missing.Value

HTH,
Nacho
 
You must log in or register to reply here.

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

Similar Threads

Excel Protection 2
How to bypass password when pasting FROM a protected workbook 3
Copying in sheet with protection with the use of a macro 5
Autofilter of Protected Sheet - Excel 2000 (not 2003 or 2007) 2
Protecting worksheet. 1
Enable autofilter in protected worksheets in Excel 2000 6
Controlling worksheet protection via VBA 0
Protection greyed out in Excel 2

Back
Top