MrExcel’s Learn Excel #424 – Toolbar Hyperlinks

MrExcel’s Learn Excel #424 – Toolbar Hyperlinks


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.

Leave a Reply

Your email address will not be published. Required fields are marked *