LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Original Picture Size in VBA?

Hello,

In Excel, you are able to reset a picture to its "Original size". I'm
wondering if it possible to get the original size in VBA. Consider this:

In Excel, select an image in one of the cells. Right click, and select
"Format Picture". In the Format Picture dialog, click the "Size" tab. At the
bottom of the tab, it shows the "Original size". That is the size I would
like to access via VBA.

On a related note, if you press the "Reset" button while recording a macro,
the code in the macro just sets the picture to a hard coded width and
height. As if that is ever useful.

BTW, I'm using an older version of Excel (Office 2000). However, I can't
find a way to get these values even in newer versions.

Howard

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Picture size increase/decrease in size using code JohnUK Excel Programming 2 December 6th 09 11:00 PM
Comment Box Size = 125% Fill Picture Size Jason W Excel Programming 1 October 27th 09 03:28 PM
Chart Picture Size in UserForm/Picture Control. Dan Excel Programming 8 May 30th 08 08:04 PM
setting for "original picture" size sumatradc Excel Discussion (Misc queries) 0 June 16th 06 04:39 PM
Keep Font original size rbutton Excel Discussion (Misc queries) 1 April 11th 06 06:31 PM


All times are GMT +1. The time now is 10:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"