I have added these macro's to my own menu ribbon. I use this file to store loads of general macro's which are always available, independent of which. To automatically create this file, just start recording a "dummy" macro (with the record button on the left-bottom of a spreadsheet) and select "Personal Macro Workbook" to store it in.Īfter recording your macro, you can open the VBA editor with Alt+ F11 and you will see the PERSONAL.XLSB file with the "dummy" recorded macro. Initially the PERSONAL.XLSB file will NOT be there.
This file will be loaded in the background every time you start Excel and makes your macro's available at any time. One way to do this is to add your macro's centrally to the file PERSONAL.XLSB (sometimes the extension might be different).
Do I have to add this macro to all 1000 workbooks? A part of the question might be how do I run this on 1000 files?.
0 kommentar(er)
