When I try to hide a column with the regular procedure (select the column,
Format, Column, Hide) I get the message "Cannot shift objects off sheet" and
the column doesn't hide.

What does this mean and why is it happening?

Thanks,
Alan

--
achidsey

Hi Achidsey,

See MSKB article # 211769:

'Cannot shift objects off sheet" error message when you hide columns in
Excel'

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

---
Regards,
Norman



"achidsey" (notmorespam) wrote in message
...

When I try to hide a column with the regular procedure (select the column,
Format, Column, Hide) I get the message "Cannot shift objects off sheet"
and
the column doesn't hide.

What does this mean and why is it happening?

Thanks,
Alan

--
achidsey

Probably Comments or Objects interfering.

This KB article addresses this problem and gives solution.

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


Gord Dibben Excel MVP

On Wed, 14 Sep 2005 16:08:06 -0700, "achidsey"
(notmorespam) wrote:


When I try to hide a column with the regular procedure (select the column,
Format, Column, Hide) I get the message "Cannot shift objects off sheet" and
the column doesn't hide.

What does this mean and why is it happening?

Thanks,
Alan

Great info. thanks for the help. Alan
--
achidsey


"achidsey" wrote:


When I try to hide a column with the regular procedure (select the column,
Format, Column, Hide) I get the message "Cannot shift objects off sheet" and
the column doesn't hide.

What does this mean and why is it happening?

Thanks,
Alan

--
achidsey