If any one can help me either by changing some settings or through VBA code.
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.
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