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: 8
Default Extract image from toolbar button

I have an Excel95 (Excel 5) workbook with an attached toolbar. Because
the toolbar is causing problems for some users, I want to instead
create the toolbar dynamically on the fly.

No problem doing this, apart from extracting the face icon. I have no
access to the original icons so I've extracted the image 'manually'. I
used the CopyFace method and pasted the resulting picture from the
clipboard as a bitmap to a worksheet (bitmap was the only option for
pastespecial). The Picture object looks exactly the same (e.g. same
resolution) as the original.

I'm now using the Picture object at run-time for the dynamic toolbar
button's face i.e.

oSheet.Pictures("Picture 1").Copy
oToobarButton.PasteFace

However, the resulting image on the toolbar button has lost some
resolution: the image is smaller, lacks definition and looks blurred.

Is there an alternative approach which will enable me to use a true
copy of the original face for my dynamic toolbar button?

Many thanks.

--
 
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
Change button image juanperez Excel Discussion (Misc queries) 0 February 5th 09 04:49 PM
Paste Button Image Sarah at DaVita Excel Discussion (Misc queries) 2 June 1st 07 08:46 PM
Toolbar Button Image Question [email protected] Excel Worksheet Functions 1 August 30th 06 09:13 PM
How to increase size of image in button (msocontrolbutton) of custom toolbar of Excel padam Excel Discussion (Misc queries) 0 August 11th 06 07:18 PM
Load image from directory for custom toolbar of Excel 2000 Padam Excel Worksheet Functions 0 August 5th 06 06:33 PM


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

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"