![personal macro workbook excel 2016 personal macro workbook excel 2016](https://i.stack.imgur.com/GCF5p.png)
I still use the VBA editor to write and maintain my code to gain access to IntelliSense. After all, who am I to mess around with someone's Personal.xlsb etc. I think I may go back with that approach rather than the Personal.xlsb and its Word equivalent. In one of my last pre-retirement projects, I worked on a coding project that I intended for a prospective client and I kept that code in its own Master Workbook and Master Document that would likely have ended up being a pair of Add-ins. I do love using OneNote to supplement my aging memory and recording solutions to various problems I've had. I'm a personal user and don't have access to SharePoint that I'm aware of. The idea of something equivalent to Custom.dic for code is also really attractive. you never know when they are going to change the value of Pi or something).
![personal macro workbook excel 2016 personal macro workbook excel 2016](https://www.repairmsexcel.com/blog/wp-content/uploads/2020/10/Copy-Macros-in-the-Personal-Macro-Workbook-1.png)
I wonder if content of some of those sheets could also be linked to master versions (i.e. I can see that as being a great way to store a documentation sheet for the workbook, constants as named ranges, conversion tables, and hyperlinks to the web as applicable. I really like your idea of the Master Workbook to hold code and sheet templates. At least I'm not crazy or alone - well, maybe we both are. All Rights Reserved.Marty: Thanks for your response. Your Personal.xlsb workbook is a common and easy target for macro viruses so if you have made a lot of customisations to the Excel environment it is worth saving a copy of this file. If you want to distribute your macros to other people then you need to Create an Excel Add-in.Īnother way to check if the Personal.xlsb file exists is to select the Developer tab, press Macros and expand the "Macros in" drop-down list. The Personal Macro Workbook provides you with a way of saving general utility macros that only you can use. Using the "Personal Macro Workbook" makes sense when you are recording a utility macro that could be used on a number of different workbooks. Storing your macros in "This Workbook" makes sense when you are manipulating data for a specific workbook.Ĭhoosing "New Workbook" makes sense when you are experimenting with the macro recorder and do not want the recorded macros to be added to the active workbook. When you record your first macro it will default to being saved in "This Workbook". If you have a Personal.xlsb file this will be stored in your Personal xlStart folder:įor more details about the exact location of this folder, please refer to the Workbooks > Startup Folders page.Įxcel 365 - C:\Users\ "user name"\AppData\Roaming\Microsoft\Excel\XLStart\Įxcel 2021 - C:\Users\ "user name"\AppData\Roaming\Microsoft\Excel\XLStart\Įxcel 2019 - C:\Users\ "user name"\AppData\Roaming\Microsoft\Excel\XLStart\Įxcel 2016 - C:\Users\ "user name"\AppData\Roaming\Microsoft\Excel\XLStart\ 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.
![personal macro workbook excel 2016 personal macro workbook excel 2016](https://i.ytimg.com/vi/D-udojyxjwQ/maxresdefault.jpg)
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.