Previous Topic Next Topic

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

Answer 1 / 1
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
0
Issa
Sep 1, 2011 at 10:00 AM
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
0
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.
0