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
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
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