Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Resize image using macro
10 views
Skip to first unread message
Gotroots
Nov 12, 2009, 5:00:01 PM11/12/09
to
When I recorded a macro to enable me to resize an image non of my actions
were recorded.
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
Nov 12, 2009, 6:04:02 PM11/12/09
to
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.
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.
0 new messages