VBA or change settings for "Picture format "

Closed
issa - Aug 24, 2011 at 07:29 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Sep 1, 2011 at 09:11 PM
Dears,

If any one can help me either by changing some settings or through VBA code.

The case:
I have excel workbook including 100 worksheets for each employee and all are the same formats (Columns & Rows).
When I make copy of each cheque from PDF file (as picture) and then make paste in each excel sheet of those 100 sheet, I need each time to go to "Format Picture" then to the "size" tab then to change the size from 100% to 42% to fit the width of the sheet.

Therefore, how can I do this automatic when I paste or any good idea that save the time.

Thank you in advance for any kind assistance.
Issa
Related:

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Sep 1, 2011 at 06:05 AM
I am not sure if there is an event that will do it as you paste picture (there might be). What I can suggest is that you create a macro that can go thru each sheet and for each picture resize it as you want
Dear Rizvisa1,

First of all thank you to your reply and help.

Can you please help me in your suggestion, I mean to give me the macro code to do what you suggested.

Thank you.

Issa
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Sep 1, 2011 at 09:11 PM
oh you can just record the macro to see how it is. Right now i will not able to execute a macro else i would have recorded.