Join Dennis Taylor for an in-depth discussion in this video Creating colorful 3D buttons for worksheet annotation and macro buttons, part of Excel Tips Weekly.
- The colorful buttons you're seeing on this worksheet…could contain text, one of them actually does.…These can also be associated with macros…and they have an interesting 3D kind of look to them…they're easy to create and they do have a functional purpose…for example, the macros that I suggested.…Let's show how to create one of these…and then use it for macros.…In most of these examples, except for the circle…we're talking about simply two shapes…put on top of one another and shaded in opposite directions.…So let's create one.…
We can do this from the Insert tab on the ribbon.…You'll see a shapes button.…This could look a little larger…depending upon your screen resolution.…I'll just pick the rounded rectangle option.…Highlight it like this.…Maybe I prefer a different color.…Notice, a contextual tab is present, the Format tab.…How about shape fill here?…Maybe a color I've used recently.…How about this one maybe?…That one?…Looks good.…Let's duplicate this, control d.…So we've got two of these.…
Take one of them, move it aside a little bit…
Note: Because this is an ongoing series, viewers will not receive a certificate of completion.
Skill Level Appropriate for all
Q: Why can't I earn a Certificate of Completion for this course?
A: We publish a new tutorial or tutorials for this course on a regular basis. We are unable to offer a Certificate of Completion because it is an ever-evolving course that is not designed to be completed. Check back often for new movies.
Excel Tips - New This Week
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.