Hello everyone,
I have a problem in Excel 2007, I need certain sheets of a workbook to be locked, but when I lock them the tables inside of the sheet lose the capability to expand/keep formatting when adding new data to them. I have seen other similar posts on the forum but no replies on them. Does any one know how to be able make it so that when sheets are locked the tables can still be manipulated to expand normally? I'm hoping that some one can help me out.
Thank you in advance
Eric.
I have a problem in Excel 2007, I need certain sheets of a workbook to be locked, but when I lock them the tables inside of the sheet lose the capability to expand/keep formatting when adding new data to them. I have seen other similar posts on the forum but no replies on them. Does any one know how to be able make it so that when sheets are locked the tables can still be manipulated to expand normally? I'm hoping that some one can help me out.
Thank you in advance
Eric.