+ Reply to Thread
Results 1 to 8 of 8

Creating Custom Button Image

  1. #1
    Registered User
    Join Date
    11-21-2010
    Location
    Sydney
    MS-Off Ver
    Excel 2003
    Posts
    5

    Question Creating Custom Button Image

    Hey all,

    Could anyone help with custom button images? I did create an add-in by using the image in the add-in and then using the "paste face"script. However, that method has its limitations! Is there any other method?

    Thanks!
    Last edited by glen.comerford; 11-23-2010 at 03:28 PM. Reason: Wrong Post Icon!

  2. #2
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Creating Custom Button Image

    what buttons? what addin did you use?
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  3. #3
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Creating Custom Button Image

    Andy Pope's Button Editor might help
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: Creating Custom Button Image

    What are the limitations that you have encountered?
    Cheers
    Andy
    www.andypope.info

  5. #5
    Registered User
    Join Date
    11-21-2010
    Location
    Sydney
    MS-Off Ver
    Excel 2003
    Posts
    5

    Smile Re: Creating Custom Button Image

    HI all,

    I tried copying a picture into the add in file i created and wrote a script to paste that picture as a button image every time the add-in opens (i.e. when excel is loaded after the add in is installed) . However, since the image is copied in the clipboard, whenever a user performs a first operation on a sheet as "paste", the picture gets pasted in the current working (new)sheet. I'm looking for another way!

  6. #6
    Registered User
    Join Date
    11-21-2010
    Location
    Sydney
    MS-Off Ver
    Excel 2003
    Posts
    5

    Smile Re: Creating Custom Button Image

    Also, since I need to install the add-in on multiple computers, I need to be able to change the image right in the source add-in file!

  7. #7
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: Creating Custom Button Image

    So maybe the solution is to clear the clipboard after pasting your image.

    Please Login or Register  to view this content.

  8. #8
    Registered User
    Join Date
    11-21-2010
    Location
    Sydney
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Creating Custom Button Image

    Thanks Andy, this works - a great idea!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1