haaconsultancy.blogg.se - december 2022

Open the VBA editor and check that personal.xlsb appears in the directory panel. If there is not, then Excel is obviously storing it somewhere else and you need to track down where that is.

Check that there is a new personal.xlsb in the startup folder. Then open Excel and record a simple macro to your personal macro file, close the file and answer yes to save the personal file etc. Go to your XLSTART directory and move your personal.xlsb ( and any other file personal.xxx) to another place (desktop say).

This is an attempt at some sort of logical approach and I have not tested it so no guarantees. You can then assign your shortcut in the settings for that macro.You might have already tried this.

Adding shortcuts can be done by selecting the macro you want to run and choosing edit from the options at the right. ALT+SHIFT+L) to quickly run your macros without going to the menu bar. You can also assign shortcuts of your choice to the macros that you keep in your personal workbook (ie. All macros in your personal workbook will be preceded by “PERSONAL.XLS!”. Just select Tools–>Macro–>Macros and choose the macro to run. You can use any of the macros saved to this workbook any time you open a spreadsheet. You can use the personal workbook in multiple ways. Just select Window–>Unhide and then select the workbook you would like to unhide. Hiding your personal workbook is as easy as selecting Window from the menu bar, clicking Hide and choosing the workbook you would like to hide. Hiding and Unhiding the Personal Workbook

The box below will appear and you will now be able to record a macro to your personal workbook.

Select from the menu bar: Tools–>Macros–>Record New Macro.

Then just rename that file to Personal.xls. The quickest way to create the new file is to right click in the folder and click New–>Text Document. Navigate to C:\Program Files\Microsoft Office\Office 10\XLStart (default install location).

Create a new personal.xls file in the XLStart folder.

Instead of copying the macros you use frequently to every workbook, Excel gives you use of a Personal Macro Workbook.įollow these steps to create your own personal.xls file: For any of the repeating tasks that you do through macros, Excel provides a way to have those commonly used actions always available to you.