I want to change the column width ( reduce the width) and get teh following
message and the command is not executed:

Message: Cannot shift objects off sheet .

What does it mean and what do I need to do to reduce the width of this column

Hi

You have some charts or command butons usw on your sheet, and resizing
columns will movie them outside sheet (to left of column A) - which is
impossible to do.


Arvi Laanemets


"Nikolaus" wrote in message
...
I want to change the column width ( reduce the width) and get teh following
message and the command is not executed:

Message: Cannot shift objects off sheet .

What does it mean and what do I need to do to reduce the width of this
column

You can solve your problem by preventing the objects from moving or
sizing with cells...

Select the object... If there more many objects, you can select them
all at once... Follow as given below...

Press F5 click on SPECIAL click option objects press
ENTER..

Once all objects are selected, keep mouse on any one of the objects,
right click the mouse Select FormatAutoShape select tab named
Properties click option "DONT MOVE OR SIZE WITH CELLS" press
ENTER.

Now you will be able to resize columns, rows and use formats as needed
on worksheet.

I hope this helps.

Selva V Pasupathy
For more on Excel, VBA, & other Resources
Please visit: http://socko.wordpress.com

I press F5, selecting Objects , pressing enter and receive the message: No
objects found

what nnow?

"Socko" wrote:

You can solve your problem by preventing the objects from moving or
sizing with cells...

Select the object... If there more many objects, you can select them
all at once... Follow as given below...

Press F5 click on SPECIAL click option objects press
ENTER..

Once all objects are selected, keep mouse on any one of the objects,
right click the mouse Select FormatAutoShape select tab named
Properties click option "DONT MOVE OR SIZE WITH CELLS" press
ENTER.

Now you will be able to resize columns, rows and use formats as needed
on worksheet.

I hope this helps.

Selva V Pasupathy
For more on Excel, VBA, & other Resources
Please visit: http://socko.wordpress.com