Hi,

I had been working long hours so I didn't have a chance to get back to this.
But you should attach that macro to the Personal Macro Workbook's
thisWorkbook object as and Open_Workbook macro. That will cause it to set
automatically anytime you open Excel.


--
Cheers,
Shane Devenshire


"ShaneDevenshire" wrote:

Hi,

First I would display the flowchart shapes toolbar. (Assuming you are using
Excel 2003 or earlier):
1. On the Standard toolbar click Drawing.
2. On the Drawing toolbar open AutoShapes, and open Flowchart, drag the
Flowchart submenu away from the AutoShapes menu by grabbing its title bar,
the gray dotted line at the top of the pop out menu.
3. To get the shapes to lock the the grid on the Drawing toolbar choose
Draw, Snap to, Grid. This will make snap to grid the default.
On a case by case basis you can activate snap to grid by press the Alt key
as you drag a shape around. But once you have set the default to Snap to
Grid, then the Alt key will temporarily turn off snap to grid as you drag.



--
Cheers,
Shane Devenshire


"#DIV/0" wrote:

Good morning,
I do a lot of flowcharting and would love to find a way to get Excel to open
with shapes set to lock to the cell grid by default (excuse me if the terms
aren't always correct - I'm translating from the Italian version of
Excel2003).

--
David M
WinXP - Office2003 (Italian)