How can I remove the formula bar on excel 2007 using vba. I have a pivot table and I don't want to display the cell contents in the formula bar. If I do hide/lock cells and protect sheet, than the pivot table cannot be updated. I was hoping to somehow remove the formula bar from the ribbon for this particular file.