Hi,

I've a sheet that is protected against insert columns, this sheet has a Excel 2007 data table that by default when you insert a new line, that line heritage the formats from the previous line.

But when i protect the sheet this functionality doesn' work and i'm getting new unformatted lines. Is there any way (macros, or functions) to protect the sheet and maintain the data table funcionalities?

Thanks In advance