I have a few worksheets within a work book, where autofit works perfectly. I have added a new sheet that is protected and locked. It draws certain data from other sheets. But the rows will not autofit the text from this sheets. If i peerform the autofit manaul it works fine. But if i remove the data from the corrosponding sheets. the rows end up blank but stay at the expanded height instead of collasping back to defaut height...???

Any Ideas