Home |
Search |
Today's Posts |
#26
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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". |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
HOW DO I SURROUND DATA WITH COLORFUL MARCHING ANTS | Excel Discussion (Misc queries) | |||
At what times do the "moving ants" appear around a cell? | New Users to Excel | |||
Turn off selection marching ants in Excel 2003 | Excel Discussion (Misc queries) | |||
How to setup "marching ants" border Excel cell? OK in MS Word. | Excel Discussion (Misc queries) | |||
Excel should include flashing cells/block and marching ants like W | Excel Worksheet Functions |