Good job on getting a button face you want. MS has a whole collection of
button faces but they're not included with Excel. You can get them but it's
a lot more work and adds more complications to something that should be
pretty simple.
As far as placing the button where you want, you should be able to place it
anywhere you want on any existing toolbar. I have a group of custom buttons
on the standard toolbar between the sorting buttons and the zoom control.
A lot of folks would consider this overkill but for me it's an ergonomics
"thing"!
Thanks for the feedback!
--
Biff
Microsoft Excel MVP
"Riccol" wrote in message
...
OK, cool, got it working, I now have an ant-killer button on my toolbar.
Thanks for taking the time to write up your instructions for me.
The only step I had trouble with was this one:
Goto the menu WindowHide
This will hide the file.
Now, save the file:
Goto the menu FileSave As
In that order, my save options were all grayed-out. So I saved it first,
then did Window/Hide, and then it let me save it.
After getting the macro/button working, it took me sometime to figure out
how to modify the button, as the "modify" button was always grayed out. I
finally figured out that after right-clicking on the button on the
toolbar, and choosing "customize" from the list that opens, you have to
click on the button in the toolbar again to "activate" it for modifying.
And it doesn't matter what's selected in the customize dialog box, you
just have to open it and then click on the button on the toolbar you want
to modify. Took me a while to figure that out.
But after I figured that out, I figured out how to use whatever image I
want for the button instead of being limited to the ones in the "change
button" box.
You need a 16 x 16 .bmp image. Save it anywhere on your computer.
Pick any cell on whatever sheet you have open and choose "Insert -
Picture - From File". Navigate to your icon and select it for insertion.
Then copy it. (Make sure you're copying the picture and not the cell. Do
that by clicking on the picture inside of the cell instead of just
clicking on the cell, then right-click, "copy".)
With the image copied, go back to where you can modify your button and
instead of choosing "edit button" or "change button", choose "paste button
image". Bingo! You've now got your own personal image for your button.
(Don't forget to go back to the cell you inserted the image in and delete
the image from it. Inserting the image into a cell first was the only way
I could figure out how to copy it to the clipboard for pasting as a
button; there may be a better way to get it copied but I couldn't find
one.)
It's pretty hard making a 16x16 image. I wanted to do an ant image with
the no symbol over it, but 16x16 is a pretty small canvas! So I settled
for a simple "AK" button. It's here if you want to try personalizing your
button. http://users.rcn.com/switch32/AntKiller.bmp
Also, small "glitch". It won't let me put the button anywhere I want it.
The only place it will let me drag it to is to the right end of the main
toolbar at the top of the window (File, View, Help, etc..). Is that normal
or should I be able to place it somewhere else?
RC
You may want to change the button face to something other than a "smilie
face". Right click the button and in the menu you'll see a couple of
options: Edit Button Image or Change button Image. The Change Button
Image selections aren't too great. So, if you don't want any of those use
the Edit Button Image option. This too, isn't great but you can play
around with it until you get something you can "tolerate".