Customized Toolbar Macro Buttons

  • Thread starter MSThinksItKnowsBetter
  • Start date
M

MSThinksItKnowsBetter

In Excel 2003 I created numerous Macros for repeated functions that aren't
available from MS. I then created (designed) my own Toolbar buttons to easily
run these Macros. Why isn't that "Copy Image" "Paste Image" and "Edit Image"
function still available for Modifying Toolbars?

Once again MS thinks it knows better!
 
P

pixiecat

I'm not finding PasteFace anywhere. I did a search for more information and
came up with nothing, both in Help and in this forum. What I'm trying to do
is copy the custom toolbar buttons I made for my custom macros in Excel 2003
to Excel 2007.
 
B

Bob Phillips

cbTable.Shapes(shapename).Copy­Picture
cbCtl.PasteFace

where cbTable is the codename of the sheet containing the picture, shapename
is the name of the shape, such as 'Picture 30', and cbCtl is an object
variable for the control being added.



--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
P

pixiecat

Would you mind backing up a few steps? I've never done anything like this
before, so I need to be walked through step-by-step. Where would I do this?
Are there more steps that would be obvious to someone who's more experienced?

Thanks.
 
M

MSThinksItKnowsBetter

So what you're saying when you say "Sorry not your own icons" is that
MICROSOFT THINKS IT KNOWS BETTER - what we their customer want...Right?

MS Giveth (Excel 2003); MS Taketh Away (Excel 2007)

Another reason NOT TO UPGRADE!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top