Hi R Rush - I was wondering if you ever found an answer to your question. I
too am trying to programmatically protect specific cells but have only been
able to protect the entire worksheet. In my scenario, I generate XML code via
Access which in turn creates an Excel spreadsheet. I have successfully
created the spreadsheet, added and formatted specific rows but the protection
tags seem to protect the entire worksheet. Any advice would be greatly
appreciated.

"R Rush" wrote:

Crud. Apparently, like protection information, SpreadsheetML doesn't retain
VBA code when transformed into XML.

I'm starting to guess that as otherwise as silly as it may be, I'm going to
have to do this programmatically.

Bah.

" wrote:

Do you know how to add VBA macros to the XL VBA representation?