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…
Skill Level Appropriate for all
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?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
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.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.