VBA or change settings for "Picture format " [Closed]

Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
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
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
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.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!