![]() This file is saved in your Excel startup folder when you close Excel. If this filename appears in the list then the file exists. If the Unhide command is enabled, press it and see if the Personal.xlsb file appears in the list. If the Unhide command is disabled, then your Personal.xlsb file has not been created. To check if the file has been created, open a blank workbook and select the View tab. Once created, this hidden file will always be accessible when Excel is open. macros that you want available all the time. This can be thought of as the place to store your so called "global" macros, i.e. This is a hidden workbook that you can use to store any general, utility macros, that you want to use (and apply) to any open workbook. This file will be created for you automatically when you choose "Personal Macro Workbook" from the Record Macro dialog box. This workbook will not exist until you have recorded your first macro AND closed and reopened Excel.Īny macros that are stored here will be available to run from any workbook. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |