Part protection of Excel 2007 tables
 

Hi,

Although this is not a VBA code/Macro related question, I thought that
the people who know the Excel object model so well would be best
placed to handle this question. Here it is:

Can I part protect an Excel 2007 (ie lock certain columns and leave
other unlocked)? eg. I want the data input columns to be unlocked and
columns with formulas to be locked. When I did this and then protected
the sheet, the table no longer behaved like a table. Was I missing
something or is this a limitation of the Tables?

Regards,
Raj