Thread: Hiding Columns
View Single Post
  #2   Report Post  
Gord Dibben
 
Posts: n/a
Default

Do you have any objects such as cell comments?

See this KB article for assistance.

http://support.microsoft.com/default...b;en-us;211769


Gord Dibben Excel MVP

On Tue, 14 Jun 2005 17:13:14 -0500, belony
wrote:


Hi,
I am new to this forum. I hope someone can help me.
I have a workbook to which I add a sheet every pay period. Actually, I
copy the sheet from the previous week and make a new, additional sheet
at the end of the workbook.
I use these sheets for batching the current payroll information and
link past columns to new. I do not remove any old info from the new
copied sheet, but I add 10 new columns to each sheet each time I copy.
I tell you all of this in case it helps with my problem.
My new sheet will not allow me to hide the columns I don't need to see.

The Error message is "CANNOT SHIFT OBJECTS OFF SHEET".
I have been hiding columns for years and years and have never gotten
any error message, much less on like this. Can anyone out there help??
Thanks so much.