Part protection of Excel 2007 tables

R

Raj

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
 

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

Top