Note that \Application Data\ is a hidden directory and won't show unless you have configured WinExplorer to show hidden folders. Normally that's going to be:Ĭ:\Documents and Settings\username\Application Data\Microsoft\Excel\XLSTART\ (Note that Personal.xls is a hidden workbook and not an Excel Add-In.)Įxcel will put it in your startup directory. This way every time you start Excel, Personal.xls will load and its macros will be available to you. If you select Personal Macro Workbook and you have not previously recorded a macro there, Excel will create it for you, naming it Personal.xls and placing it in your Excel startup directory. If you use the Macro Recorder to record a macro, the dialog box asks where you want to store the macro: (a) the active wb, (b) a new wb or (c) in your Personal Macro wb. This is a workbook that Excel automatically creates. Excel inserts TRANSPOSE () on the Formula bar and opens the Function Arguments dialog box where the Array argument text box is selected. Click the Lookup & Reference command button on the Ribbon’s Formulas tab and then choose the TRANSPOSE option from the button’s drop-down menu. the macro is a "generic" macro it is better to place the macro in your Personal Macro Workbook. Select the blank cell range B6:D7 in the worksheet. If you wish to always have the macro available and not just when one particular workbook is open - i.e.
0 kommentar(er)
