aspect ratio

  1. E

    Column size / aspect ratio / view changes between laptops

    Hi, I've got this sheet where I've sized the columns, rows & zoom perfectly to fit a header picture on a single screen page where you don't have to scroll to see any of the data. Also, cells were sized specifically to overlay on top of specific parts of the header image. I just opened the same...
  2. V

    VBA to Crop Image to 1:1 Aspect Ratio

    Hello, I am attempting to use VBA to crop images to a 1:1 aspect ratio. Here is the code that I am using currently: With shp Width = .Width Height = .Height TCrop = Width - Height Hcrop = TCrop / 2 End With With .PictureFormat .CropLeft = Hcrop .CropTop = 0 .CropBottom = 0 .CropRight = Hcrop...
  3. V

    Help cropping image to 1:1 Aspect Ratio

    Hello, I have searched the internet and these forums pretty extensively trying to come up with an answer to my question. Essentially, I am trying to take an image with an aspect ratio other than 1:1 and crop it to an 8 inch by 8 inch size. I have found that 72 points should correspond to 1...
  4. D

    Keeping aspect ratio and orientation when inserting pictures

    Hey everyone, Rory helped me last time get the declaration correct for my function but now my colleague wants to maintain aspect ratio and orientation but still have all the pictures the same size.( either legal or landscape orientation) I can maintain original aspect ratio by having -1 for...
  5. J

    inserting picture but need the aspect ratio to not control the size

    I have a form that requires pictures to be placed in it. I have added a button and assigned the following macro to set the size and placement of the picture I need. It works great, except the height does not fit correctly. It seems the height is being controlled by the aspect ratio of the...
  6. S

    Macro to insert picture into a cell

    Hi Excel Gurus :) I am working on a macro allowing me to insert a picture into a cell activated with a button. I'd like to find out how this could be done. After clicking on a button "Insert Drawing" a generic windows dialog box should pop up asking me to select a picture I'd like to insert...
  7. T

    "reset" picture programmatically with vba

    Hey guys, I've got a workbook that runs on mac and pc. One of the problems with this is that pictures added in one platform lose their aspect ratio when opened on the other. This can be fixed by using the "reset" button in the "format pictures" tab on the ribbon, but I don't know how to do...
  8. T

    "reset" pictures programatically

    Hey guys, I've got a workbook that runs on mac and pc. One of the problems with this is that pictures added in one platform lose their aspect ratio when opened on the other. This can be fixed by using the "reset" button in the "format pictures" tab on the ribbon, but I don't know how to do...
  9. J

    Distorted picture in header

    I'm using Excel 2010. I put a TIF file in a header and print it. Then I change the normal font size and print it again. The TIF is squished and squashed depending on the normal font setting. I have not been able to prevent this by any combination of the "lock aspect ratio" or "Relative to...
  10. M

    Inserting Picture with VBA alters aspect ratio in 2010, but not 2007

    Hi, I am using the below code to check for existing image (and delete if it exists), and then add an image into a cell range - centred and fit to size (/1.05). This works fine in Excel 2007, but in Excel 2010, the image is being squashed horizontally > < ... any ideas why? Sub...
  11. I

    Chart plot area aspect ratios different?

    I have a number of charts in the same workbook. Some of the charts have a different size plot area. Not the chart itself, but the white "pasteboard" that is behind it. Because I ultimately output all of my charts to pdf's and then to gifs (in Photoshop) this change is aspect ratio is messing me...

Some videos you may like

This Week's Hot Topics

Top