![]() 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). 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.
0 Comments
Leave a Reply. |