+ Reply to Thread
Results 1 to 1 of 1

Shape objects (text boxes) change size and appearance on different machines

  1. #1
    Registered User
    Join Date
    03-10-2017
    Location
    Vancouver, Canada
    MS-Off Ver
    2010
    Posts
    1

    Shape objects (text boxes) change size and appearance on different machines

    Hi there,

    I use Excel to produce calculations, and as such need a header block at the top of each sheet. To achieve this, I've created a grouped set of text boxes as shown in the attached to present the information I desire at the top of each sheet. This allows me to readily update the header block info manually, or via VBA.

    The issue I have is that after carefully sizing and positioning the text boxes to look good on my machine, as soon as a colleague opens this on another computer everything shifts, and also prints incorrectly. The text spacing changes, the relative position of the text boxes is altered. It's a mess.

    Is there any plan to fix this issue? Is there a workaround to avoid it? Possibly by use of Forms, or do these shift too?

    Note: I'm fully aware of the Header/Footer feature, but this is really limited which I why I moved away from it. My question relates more generally to shifting shape objects, which appears to be a severed limitation in what can be achieved with them when sharing workbooks between machines. So please limit responses to this issue; the Header/Footer feature is too clunky for my use.

    Cheers,

    Dan
    Attached Images Attached Images

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Data label text boxes change their size
    By erpokorp in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 08-09-2019, 10:14 AM
  2. [SOLVED] Help with VBA to change font size in a shape
    By happymonody in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-12-2016, 05:33 AM
  3. [SOLVED] Change Shape Size / Keep its Position
    By Broobi in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-10-2014, 12:05 PM
  4. Shape size based on text in shape
    By mwc48910 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-23-2011, 05:43 AM
  5. Comments boxes changing size and shape
    By Meredith Kiraly in forum Excel General
    Replies: 2
    Last Post: 09-11-2007, 11:20 PM
  6. How can I change the shape and size of the boxes in an org chart?
    By helenfanig in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-02-2006, 02:20 PM
  7. Replies: 1
    Last Post: 03-03-2005, 02:06 PM

Tags for this Thread

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