![]() ![]() *Just a quick note here… if you float back and forth between Excel 2010 and Excel 2013 on the same machine, Excel locks the personal macro workbook for editing when you open the first Excel instance. ![]() Isn’t that just the height of lazy? (I mean efficient!) Close Excel and say Yes when prompted to save changes to the Personal Macro Workbook. ![]() Now open the Modules folder and double click Module 1.Paste the following code in the code pane:Īpplication.OnKey "%", "OpenPowerPivot".Double click the ThisWorkbook module inside it.If it’s not showing, press CTRL+R to display it.) (The project explorer is the treeview on the left. Find VBAProject(Personal.xlsb) in the Project Explorer.(That will create your personal macro workbook.) Choose to store it in the Personal Macro Workbook.But if you’ve never written a macro, or you’ve never used the personal macro workbook, here’s how you do it: If you know your macros, or you already have code in your personal workbook, then add the Workbook_Open line and the Sub OpenPowerPivot to your project. It’s pretty short, works with Excel 20, and can be stored in the Personal Macro Workbook.* Well, I got tired of waiting… not that I ever expected they’d release a patch for that or anything. Since Alt + F12 is currently empty, and since it’s right next to the VBE’s Alt + F11 shortcut, it only seems logical that Alt + F12 would make a logical choice. When I was down at Microsoft for the MVP Summit, I suggested that, as the “other most powerful part of Excel” that PowerPivot, like the Visual Basic Editor, should be given it’s own keyboard shortcut. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |