![]() If the Unhide tool (in the Window group) is not available, then the Personal Macro Workbook has not been created on your system. If you want a quick way to see if one is available on your system, display the View tab of the ribbons. The Personal Macro Workbook isn't created by default on a system. ![]() (Actually it is hidden so it doesn't interfere with the work you are doing on other workbooks and so that you don't inadvertently make changes in it.) This special workbook is known as the Personal Macro Workbook, which is stored in a file named Personal.xlsb. This special place is, itself, a workbook, and it is normally hidden from prying eyes. The answer, of course, is to place it in a special place that is accessible regardless of the workbook on which you are working. Where, then, does one put a macro so it can be used over and over again? A good number of the macros I create for these reasons are ones I need to use over and over again, and I'll bet you are in the same boat. Macros are often created to save time and energy, make Excel work the way we expect it to work, and to make repetitive, mind-numbing tasks somewhat more bearable.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |