ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Keeping objects with cells (https://www.excelbanter.com/excel-discussion-misc-queries/187568-keeping-objects-cells.html)

martinson

Keeping objects with cells
 
In Excel 2003, it was a setting for all workseets that objects would move
with cells. I can't find that in Excel 2007.
--
martinson portland

Niek Otten

Keeping objects with cells
 
Right-click the objectSize and properties, Properties tab. There it is

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"martinson" wrote in message ...
| In Excel 2003, it was a setting for all workseets that objects would move
| with cells. I can't find that in Excel 2007.
| --
| martinson portland



martinson

Keeping objects with cells
 
Is there a way to do the entire sheet?
--
martinson portland


"Niek Otten" wrote:

Right-click the objectSize and properties, Properties tab. There it is

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"martinson" wrote in message ...
| In Excel 2003, it was a setting for all workseets that objects would move
| with cells. I can't find that in Excel 2007.
| --
| martinson portland




Gord Dibben

Keeping objects with cells
 
F5SpecialObjectsOK

Right-click on one of the selected objects and Format AutoshapePropertiesMove
and size with cells.


Gord Dibben MS Excel MVP

On Thu, 15 May 2008 08:44:01 -0700, martinson
wrote:

Is there a way to do the entire sheet?



martinson

Keeping objects with cells
 
I've done that. Whe I delete rows above, the objects stay where they are,
they don't move with the cells. It's making me crazy!!
--
martinson portland


"Gord Dibben" wrote:

F5SpecialObjectsOK

Right-click on one of the selected objects and Format AutoshapePropertiesMove
and size with cells.


Gord Dibben MS Excel MVP

On Thu, 15 May 2008 08:44:01 -0700, martinson
wrote:

Is there a way to do the entire sheet?




Gord Dibben

Keeping objects with cells
 
Cannot replicate your problem in 2003 version so not sure what to tell you now.

Maybe wait for someone else to read this and lend a hand.


Gord

On Wed, 9 Jul 2008 13:30:00 -0700, martinson
wrote:

I've done that. Whe I delete rows above, the objects stay where they are,
they don't move with the cells. It's making me crazy!!
--
martinson portland


"Gord Dibben" wrote:

F5SpecialObjectsOK

Right-click on one of the selected objects and Format AutoshapePropertiesMove
and size with cells.


Gord Dibben MS Excel MVP

On Thu, 15 May 2008 08:44:01 -0700, martinson
wrote:

Is there a way to do the entire sheet?




All times are GMT +1. The time now is 05:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com