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