Guys,

Does anybody know the coding for a Macro to be able to automatically set a spreadsheet to Snap to Grid?

I have tried recording a macro, buy selecting the Draw menu, then Snap and then highlighting Snap to Grid, but when I view the Macro code nothing has recorded.

Any ideas?

Howdy. Do you mean objects on the spreadsheet? If so, your macro needs to select all objects.

Howdy. Do you mean objects on the spreadsheet? If so, your macro needs to select all objects.

There are two things that I would like to achieve, when the spreadsheet is opened the user can click the macro button and format the spreadsheet so when objects are placed they snap to grid.

Also, if the user forgets to click the macro button upon opening the worksheet, after object have been placed a button can be pressed that will snap those objects to grid.

Do you know what the coding for either of these requests would be?

As mentioned I have tried recording a macro, but it does not work.