![]() |
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 |
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 |
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 |
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? |
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? |
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