Faster At Excel

  • Home
  • Book: Excel Shortcut Bible

  • Shortcuts
  • Blog
  • Archives
  • Links
  • My Account
  • Login
  • About
  • Contact

Basic Excel Macros: Part 3 Of 3, Personal.xlsb & Adding A Macro To Your Quick Access Toolbar

October 25, 2016 by Terp Leave a Comment

(This is Part 3 of a 3-part series on Basic Excel Macros. Part 1 is Creating & Saving Excel Macros. Part 2 is Editing & Deleting Excel Macros).

 

Personal.xlsb Items — Basic Excel Macros

At some point you may find that PERSONAL.XLSB for some reason isn’t opening automatically when Excel starts.  To solve this, first go to File and click on Options (or hit Alt+F+T), then select Add-Ins (or Alt-F-T-A), which opens the dialog box below.  Once in this dialog box, got to “Manage” on the bottom, select “Disabled Items” and click “Go.”  PERSONAL.XLSB is probably listed there – and if so, Enable it.

save-excel-macro

If you want to create a macro only for one specific workbook, you need to store it in “This Workbook” instead of “Personal Macro Workbook” (PERSONAL.XLSB) by selecting the appropriate item in the drop-down below:

save-excel-macro

 

Adding An Excel Macro To Your Quick Access Toolbar

Once you have your macro, you can also put it in your QAT using the same method you did to customize your QAT.  You right click on the Ribbon/QAT, click Customize Quick Access Toolbar, then (below) choose Macros.  From there, select your macro and move it to the QAT.

add-excel-macro-qat-quick-access-toolbar

You can also modify the macro’s QAT icon after you add it to the QAT.  First, select the macro in the dialog box for customizing your QAT.  Click on Modify…, then click on the icon you want in the Modify Button dialog box.

excel-macro-qat-quick-access-toolbar-icon

That’s it for a basic introduction to macros.

Note: There are many outstanding sites devoted to or heavily focused on macros.  Just Google “Excel macros” or “VBA” or “Visual Basic.”  You can also check out the MrExcel forum or some of Chandoo’s free material.

 

Filed Under: Excel Macros Tagged With: Excel macros

Leave a Reply Cancel reply

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

Post Categories

Tags

Alt Shortcuts Books challenges Charts comments cut copy paste data Double Click Excel Formulas Excel Keyboards Excel Keyboard Shortcuts Excel macros Excel Mouse Shortcuts Excel Shortcuts Excel Speed Tricks F-Key Shortcuts Filter Find & Replace Font format Format Cells Format Painter Formatting freeze panes Hybrid Shortcuts Menu Key Open Paste Formats Paste Special Paste Values Products Quick Access Toolbar - QAT save Selection and Navigation Sort

Recent Posts

  • 3 Ways To Convert Text To Numbers In Excel
  • 5 Quick Data Set Up Excel Shortcuts
  • Excel Shortcut Bible: Comprehensive Excel Shortcut Book
  • 7 Easy Excel Speed Tips
  • Basic Excel Macros: Part 3 Of 3, Personal.xlsb & Adding A Macro To Your Quick Access Toolbar

© 2016 Faster At Excel