+ Reply to Thread
Results 1 to 3 of 3

help - snap to grid

  1. #1
    Registered User
    Join Date
    08-24-2006
    Posts
    2

    help - snap to grid

    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

  2. #2
    Registered User
    Join Date
    08-24-2006
    Posts
    2
    sorted

    if anyone else needs to do it i used this code in the workbook macro:

    Private Sub WorkBook_Activate()
    Application.CommandBars.FindControl(ID:=549).Execute
    Application.CommandBars.FindControl(ID:=549).Enabled = False
    End Sub


    Private Sub WorkBook_Deactivate()
    Application.CommandBars.FindControl(ID:=549).Enabled = True
    Application.CommandBars.FindControl(ID:=549).Execute
    End Sub

  3. #3
    Registered User
    Join Date
    07-10-2014
    Location
    Miass
    MS-Off Ver
    2003 & 2007
    Posts
    1

    Re: help - snap to grid

    elchiefo, thank you very much!
    I looked for this mode for a long time and found it finally!
    And this is the only place, where I could found this.
    Thanks!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1