More tricks for your Excel toolbars, including how to edit the icons or how to add an icon to the toolbar that opens a particular webpage, perhaps www.MrExcel.com! Episode 424 shows you how.
This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!
This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!
Transcript of the video:
Welcome back to the MrExcel netcast, I'm Bill Jelen.
Another trick here for Excel ‘97 through Excel 2003, when we're dealing with our standard toolbars.
When talking about how to customize those toolbars, right click a toolbar and choose Customize and we now have the Customize dialogue.
As long as this dialog is displayed, there's all kinds of things we can do to our toolbars.
For example: if you don't like an image that's on a toolbar, you can right click, Change the Button Image or actually go through and edit the button image.
It's very tedious, but you can go through and actually, pixel-by-pixel add new color, will cut this out here, I'll be back in a minute, hang on.
Hey, welcome back, just a couple more pixels, all right, there we go and click OK.
And now we change the icon in that toolbar icon.
If you don't like it, just go through and say reset.
Another interesting thing we can do is: we can add brand new icons that initially do nothing.
So I'm going to go down here to the Macros item, where there's two different icons, either the “nothing” icon or the happy face icon.
I put the “nothing” icon up there, now right click the icon, Change Button Image and we'll choose a different image, maybe the heart.
And then right click, Default Style, finally right click, Assign Hyperlink, Open and I can specify favorite webpage.
MrExcel, that'd be a great one, click OK, click Close.
Now if I ever need to open MrExcel, I just click on the icon, Excel will open Internet Explorer and take me right to that web page from Excel.
Lots of great little tricks you can do on your icons, be sure to step back on Friday for some wild tricks you can do as a great prank, the next time your manager is out of the office and leaves his door unlocked.
See you then, thanks for stopping by, I will see you next time for another NetCast from MrExcel.
Another trick here for Excel ‘97 through Excel 2003, when we're dealing with our standard toolbars.
When talking about how to customize those toolbars, right click a toolbar and choose Customize and we now have the Customize dialogue.
As long as this dialog is displayed, there's all kinds of things we can do to our toolbars.
For example: if you don't like an image that's on a toolbar, you can right click, Change the Button Image or actually go through and edit the button image.
It's very tedious, but you can go through and actually, pixel-by-pixel add new color, will cut this out here, I'll be back in a minute, hang on.
Hey, welcome back, just a couple more pixels, all right, there we go and click OK.
And now we change the icon in that toolbar icon.
If you don't like it, just go through and say reset.
Another interesting thing we can do is: we can add brand new icons that initially do nothing.
So I'm going to go down here to the Macros item, where there's two different icons, either the “nothing” icon or the happy face icon.
I put the “nothing” icon up there, now right click the icon, Change Button Image and we'll choose a different image, maybe the heart.
And then right click, Default Style, finally right click, Assign Hyperlink, Open and I can specify favorite webpage.
MrExcel, that'd be a great one, click OK, click Close.
Now if I ever need to open MrExcel, I just click on the icon, Excel will open Internet Explorer and take me right to that web page from Excel.
Lots of great little tricks you can do on your icons, be sure to step back on Friday for some wild tricks you can do as a great prank, the next time your manager is out of the office and leaves his door unlocked.
See you then, thanks for stopping by, I will see you next time for another NetCast from MrExcel.
