I'm using Excel 2007 and couldn't find a way to keep the setting of
"Drawing Tools - Format - Align - Snap to Grid",
as when the file opens it's disabled again.
Tried also to find a way of using VBA to put something into ThisWorkbook code or into Worksheet_Activate() function, so it will be activated on the startup, but the examples were for XL2003 with CommandBar, not sure how to convert it to XL2007.
Actually all I need is to have the two vertical lines, Shapes in Sheet1, to have the feature of Snap-to-Grid to be On, instead of manually doing it on opening the file (even if I added a button on the Quick Access Toolbar, QAT for that).
Thanks in advance.
"Drawing Tools - Format - Align - Snap to Grid",
as when the file opens it's disabled again.
Tried also to find a way of using VBA to put something into ThisWorkbook code or into Worksheet_Activate() function, so it will be activated on the startup, but the examples were for XL2003 with CommandBar, not sure how to convert it to XL2007.
Actually all I need is to have the two vertical lines, Shapes in Sheet1, to have the feature of Snap-to-Grid to be On, instead of manually doing it on opening the file (even if I added a button on the Quick Access Toolbar, QAT for that).
Thanks in advance.
