Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-22-2014, 08:29 AM
Guloluseus Guloluseus is offline Sizing cells to pics (or even vice versa?) Windows 7 64bit Sizing cells to pics (or even vice versa?) Office 2010 32bit
Competent Performer
Sizing cells to pics (or even vice versa?)
 
Join Date: Mar 2013
Posts: 168
Guloluseus is on a distinguished road
Default Sizing cells to pics (or even vice versa?)

I have a long spreadsheet (Excel 2010) imported from word as a copy and paste (i.e. the original table was in word, I opened word doc, selected all, and pated into excel). There were about 20 original word docs that had to be comined into the one excel sheet.

I have 8 columns, 7 of which are straightforward text, 1 (column D) contains a picture. These vary in size and shape (some square, some long rectangle, some tall rectangle) and were taken from a 3rd source into the sheet.

I have checked in "size and properite/ size, and all pics are set to "move and size with cell".



The question- I need to set all pictures to be locked in size, so they do not scale with cells, and to be able to set the row height to be slightly greater than the pic. I searched for VBA macros that wold help, so far I can only foind ones that assist with importing pics.

Any help would be mch appreciated, if you need more details, let me know.

thanks
Reply With Quote
  #2  
Old 07-27-2014, 11:24 AM
whatsup whatsup is offline Sizing cells to pics (or even vice versa?) Windows 7 64bit Sizing cells to pics (or even vice versa?) Office 2010 32bit
Competent Performer
 
Join Date: May 2014
Posts: 137
whatsup will become famous soon enough
Default

Hi

I don't see a problem.
Copy part of it and insert to a spreadsheet. Record a macro while performing the required steps manually on one picture. That gives you an idea what the code looks like. Afterwards you can adjust in a loop all pictures/cells the same way.

If you need more help, please upload a small example of the spredsheet what it looks like after copy.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I keep graph sizing and location for reuse on a monthly basis lynchbro PowerPoint 0 06-09-2014 08:06 AM
Sizing cells to pics (or even vice versa?) Word paper sizing Wordmatching Word 5 05-24-2012 02:02 PM
How do I type on multiple pics? TimHudson Drawing and Graphics 0 07-28-2011 10:28 AM
Sizing issue dunringil PowerPoint 0 03-29-2011 10:56 AM
Word loses image sizing when I reopen file rbz1949 Drawing and Graphics 4 06-24-2010 11:19 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:33 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft