How to set default text box properties (object positioning)
Results 1 to 5 of 5

Thread: How to set default text box properties (object positioning)

  1. #1
    Board Regular JenniferMurphy's Avatar
    Join Date
    Jul 2011
    Location
    Silicon Valley, CA, USA
    Posts
    1,114
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default How to set default text box properties (object positioning)

    I almost always want text boxes to keep their size and location regardless of what happens with the surrounding cells. So I end up manually right-clicking the border, selecting Size and Properties, clicking Properties, and clicking Don't move or size with cells.

    This page says that I can set the default properties by right-clicking the border and selecting Set as Default Text Box.

    https://support.office.com/en-us/art...4-b06d28e581ce

    This doesn't work on my system.

    Is there a way I can get new text boxes to have this setting?
    Last edited by JenniferMurphy; Sep 13th, 2017 at 12:14 AM.
    Using Office 2007 Pro on Win XP Pro

  2. #2
    Board Regular
    Join Date
    Nov 2013
    Location
    Denver, Colorado - XFD1048576 - MORE Stuff here near the end. And what if you add even more stuff a
    Posts
    615
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How to set default text box properties (object positioning)

    Hi JenniferMurphy - Although this isn't exactly what you asked, you might think of trying something like the simple code below which selects all objects and makes them FreeFloating. Hope this helps get things started.

    Code:
    Sub JenniferMurphy_FreeFloatingObjects()
        ActiveSheet.Shapes.SelectAll
        Selection.Placement = xlFreeFloating
    End Sub
    Happy Excelling ,

    goesr

    To enter code in your post use the format below. Click the link for more detail.
    [CODE] ... Your Code Here ... [/CODE]

  3. #3
    Board Regular JenniferMurphy's Avatar
    Join Date
    Jul 2011
    Location
    Silicon Valley, CA, USA
    Posts
    1,114
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How to set default text box properties (object positioning)

    Quote Originally Posted by goesr View Post
    Hi JenniferMurphy - Although this isn't exactly what you asked, you might think of trying something like the simple code below which selects all objects and makes them FreeFloating. Hope this helps get things started.

    Code:
    Sub JenniferMurphy_FreeFloatingObjects()
        ActiveSheet.Shapes.SelectAll
        Selection.Placement = xlFreeFloating
    End Sub
    Interesting. A couple of questions:

    What shapes does this affect other than text boxes?

    How to I invoke it? Do I assign it to a keyboard shortcut and run it manually on each sheet? Do I set up so it runs when each sheet is activated? (I'm not sure how to do that.)


    I take it that there is no way to set the default so that all new text boxes have this setting.
    Using Office 2007 Pro on Win XP Pro

  4. #4
    Board Regular
    Join Date
    Nov 2013
    Location
    Denver, Colorado - XFD1048576 - MORE Stuff here near the end. And what if you add even more stuff a
    Posts
    615
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How to set default text box properties (object positioning)

    Hi JenniferMurphy - This macro will affect ALL SHAPES on the Active Sheet. I can be invoked the same way any macro is run and could be assigned to a keyboard shortcut or even made to run automatically when a spreadsheet is opened.

    I do not know any way to set the Default for Text Boxes as you requested, that is why I suggested possibly a work around. I would be glad to help you if you need some assistance in making the macro work. Good luck.
    Happy Excelling ,

    goesr

    To enter code in your post use the format below. Click the link for more detail.
    [CODE] ... Your Code Here ... [/CODE]

  5. #5
    Board Regular Norie's Avatar
    Join Date
    Apr 2004
    Location
    Stirling, Scotland
    Posts
    75,104
    Post Thanks / Like
    Mentioned
    60 Post(s)
    Tagged
    6 Thread(s)

    Default Re: How to set default text box properties (object positioning)

    Jennifer

    When you set a default textbox it's only default formatting, e.g. fill colour, font etc, that are set, not a property like Don't move or size with cells.
    If posting code please use code tags.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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