I have used Excel since 1992, and I have never see this error message before. I'm now a new Office 2007 user, so I don't know what the problem is. I get the "Can't shift objects off sheet" error whenever I try to insert columns or rows.

The spreadsheet contains NO "objects" but it's an xlsm sheet because I have macros. The macros only select a range of cells, and them sort them various ways. Apparently Excel doesn't like me messing with the range AT ALL. The earlier versions of Excel had no problem - they just let an extra column drop off to the right, or an extra row drop off at the bottom and sorted everything else, so you had to modify your macros whenever you changed your range. And I'm prepared to do that.

But I apparently have to use an xlxs sheet (I'm still not clear on why we have different sheets in this version - macros work in .xlsx as well, and let me insert columns and rows). Or do I have to delete all my macros and start over any time I need to change the layout in xlsm format?

Why do I need xlsm format? Any reason?