ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Resize image using macro (https://www.excelbanter.com/excel-worksheet-functions/248326-resize-image-using-macro.html)

Gotroots

Resize image using macro
 
When I recorded a macro to enable me to resize an image non of my actions
were recorded.

I want to be able to select any image contained in a workbook sheet and
click a command button to resize the image.



Luizvs

Resize image using macro
 
You may be talking about Excel 2007.
Macro recorder does not work like older version of Excel, because picture
and some other objects do not "belong" anymore to worksheets.
To do that you may put your hand into the code.
Start trying...
ActiveSheet.Picture
.... to access all pictures objets to resize then the way you wish.


"Gotroots" wrote:

When I recorded a macro to enable me to resize an image non of my actions
were recorded.

I want to be able to select any image contained in a workbook sheet and
click a command button to resize the image.




All times are GMT +1. The time now is 03:41 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com