+ Reply to Thread
Results 1 to 2 of 2

Objects not resizing with cell

  1. #1
    Registered User
    Join Date
    05-21-2018
    Location
    Philadelphia, United States
    MS-Off Ver
    2010
    Posts
    1

    Objects not resizing with cell

    I have multiple .pdf objects located in my file. I want them to move and size with the cell in which they are contained. I formatted them as such by selecting "Move and size with cells" in the object properties. For some reason, when I filter in the document, the objects move and resize down to nothing, but then they do not resize back up to their original size once I take the filter off. I have no idea how to fix this.

  2. #2
    Forum Expert Roel Jongman's Avatar
    Join Date
    03-28-2015
    Location
    Netherlands
    MS-Off Ver
    Office 365
    Posts
    1,483

    Re: Objects not resizing with cell

    objects can resize (relative) to the size of the cells but hiding and unhiding is not part of the resize so when you hide a row the object goes to minimum size and since the linked cell is no longer visable the objects kind of disconnect from that cell. simular as you can manually drag an object from one cell to another.

    basicly hiding objects by hiding rows is not possible by normal functionality
    it might be possible with vba coding.

+ 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. cell resizing
    By phillyd023 in forum Excel General
    Replies: 1
    Last Post: 09-05-2014, 05:16 PM
  2. [SOLVED] Resizing a cell issue
    By greggpetersen75 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-01-2014, 06:05 PM
  3. Cell Resizing
    By windaroo in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-05-2010, 09:06 PM
  4. Deleting and resizing the calendar objects
    By Bobmckelvy in forum Excel - New Users/Basics
    Replies: 0
    Last Post: 09-16-2006, 08:31 PM
  5. Resizing cells in a selection without resizing entire sheet
    By Danielle via OfficeKB.com in forum Excel General
    Replies: 4
    Last Post: 08-11-2006, 05:10 PM
  6. [SOLVED] cell resizing
    By DZ in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-07-2006, 07:45 AM
  7. Resizing a cell
    By gpearson in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-23-2006, 07:00 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