i have a worksheet which i'm developing for internal use at work. its basically a layout in which the user will stack a series shapes on top of each other in line with some gridlines.
for it to work correctly i need to have snap to grid turned on. this means the shapes align with the gridlines and prevents the user from just placing them out of alignment anywhere else on the sheet
if i turn on snap to grid, then save the file, when the file is reopened the snap to grid function is not on ie: excel starts with snap to grid turned off.
ideally the snap to grid function needs to be on all the time as i need to make the sheet as simple as possible ie: cannot just ask them to turn on snap to grid whenever they open the sheet
is there anyway snap to grid can be kept on, either as part of the form or as a macro that will run when the file is opened?
cheers in advance
Bookmarks