Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Prevent Editing of Worksheets w/in SpreadsheetML
I need to be able to lock worksheets against being edited (well, and allow
sections to be editable). This would be a trivial task, but I need to be able to do it by manipulating the XML representation of an Excel document (working against Excel 2003, for the record). I can't simply use Excel to do this, save it to XML, and then see what's changed, because Excel strips out protection information when you do that. I've spent a great deal of time looking at the schemas, fiddling with a SpreadsheetML file and seeing what elements and attributes pop up when... but no luck. I've figured out how to Protect the Workbook and how to Protect a Worksheet, and I can find attributes that allow/disallow pretty much anything you'd like to be able to restrict on cells... except for content editing. I simply cannot find where I: 1) Tell Excel to prevent the editing of cells. 2) Tell Excel to allow the editing of specific cells while the rest of the sheet is locked. Does anyone know how to do this? I'm at loss. Thanks! Richard |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Removing protections that prevent me from editing formulas. | Excel Worksheet Functions | |||
How to prevent editing within a specific cells? | Excel Discussion (Misc queries) | |||
How do I prevent editing in a cell based on the value in another? | Excel Worksheet Functions | |||
Prevent Locked for Editing on a network | Excel Programming | |||
Permit DoubleClick but prevent other editing | Excel Programming |