Forum Discussion
Object positioning
How was the diagram created? Was it simply a diagram created by hand? Changing the size of the underlying mesh can change the shapes, depending on their settings. Rotating shapes is unusual, though.
Many things are possible using VBA. What is desirable or worth the effort is another matter. For example, once the shapes have been positioned manually a 'record button' could store the position and visibility of shapes to a data table on a hidden sheet. That would allow a 'reset' button that takes the diagram back to a default state. The properties of Excel shapes are sufficient to allow the shape to be extruded and positioned in 3D with changing lighting options.
For some slightly over the top graphics see
- Thanks. One last question. When you manually reposition a shape does it always reappear in the last spot it was placed in when used again?
Thank You again.
JohnOpening and closing files should not cause shapes to move or change proportions. Changes that are made to the grid can have drastic repercussions depending on the shape properties.
The default is for shapes to move and size with the grid.