The Customize Quick Access Toolbar list box on the right side of this dialog box shows all three of the default buttons in the order in which they now appear on the toolbar.

Then, click the Quick Print option in the Popular Commands list box on the left and click the Add button.

Before you can add the buttons to the Quick Access toolbar, you need to replace Popular Commands with Review Tab by selecting this option on the Choose Commands From drop-down list.

The first Copy and Paste buttons are the regular command buttons that were on the Standard toolbar.

You can add either one, although the ones with the drop-down menus are much more versatile.

He has written all editions of Excel For Dummies, Excel All-in-One For Dummies, and Excel Workbook For Dummies.

I then went to the Commands toolbar Macros, and dragged SmileyFace macros to the main toolbar.

I then changed the images, modified the text, and it worked locally.

I attached the macros to the document using the attach button.

When I coied the Microsoft Excel Toolbars.xlsx file over (and dropped it in the proper location), the toolbar did appear.

Longer-term, maybe theres a way to override this default behavior and point to a local copy of the toolbars stored in the distributed file itself.

Or, maybe you can use the toolbar file as a template for the distributed spreadsheet.

I was familiar with the rather kludgy way of resolving the issue (transferring the whole directory), but I was looking for a simpler solution to embed the toolbar within the spreadsheet.

Provide details and share your research But avoid Asking for help, clarification, or responding to other answers.

Making statements based on opinion; back them up with references or personal experience.

Not the answer youre looking for Browse other questions tagged excel vba excel-2011 or ask your own question.

Excel For Mac Customize Toolbar