★ Get the example file ★ Sign up for our free Insiders program and get the example file: exceloffthegrid.com/insiders File Reference for this video: 0242 Function Library.zip
Outstanding! I have intended to develop this capability for quite some time, but couldn’t wrap my heads around how to do it. Your approach is clever. Thank you.
It's worth noting that many people would like to pursue this for work they do on their Company Issued PC's... These days many companies are blocking the ability to create and store a Personal Macro Workbook under the guise of security. I know this, because my company did it. A work around is to save your personal Macros as an Excel Add-in and load it. That way you can still create one.
Using Excel Add-in is a better solution as many custom functions engineered with lambda can be workarounds for not using small VBA Macros in companies. I’m waiting with impatience Mark’s video to show us how to do it in a fast and furious way!
Yeah - the current VBA and security world is an absolute mess. That is part of the reason why I showed all the code and provided a text file. Some users can run VBA, but can’t unblock downloaded VBA macros. Good news is that the process is almost identical if using an add-in.
Thank you, Mark. This is a powerful addition to Excel and a great Christmas present for Excel users. Thanks again. Have a wonderful, peaceful Christmas.😀
Excellent idea to use and manage Lambda functions. I was wondering, whether the same can be achieved using Office Scripts rather than VBA. There are several advantage using Off scripts e.g can be shared with colleagues, can work on excel online and also no need to save file in xlsm format.
The issue with Office Scripts is the lack of easy interface - i.e we can’t add a ribbon button. But it would be possible. It would just need to be a parameterized script that contains all the LAMBDA code inside the script as text. Maybe I will add that to the ideas log.
Great video, and a clever way of handling these custom functions. I always have problem with my Personal Macro, it seems to want to open whenever I view an Excel spreadsheet in the Windows Explorer.
I gave up trying to view spreadsheets in Windows Explorer a long time ago, it was just to buggy. So, unfortunately, you might get the same issues with this.
Hi Mark, great video/idea as always! Was wondering though, what about saving a workbook (with the custom functions) as a template within XLSTART then rolling it out to colleagues to do the same? Cheers, Oliver
Using a template in XLSTART is a good option. The issue for distribution to many users is maintenance and updating. As different users will have different versions. A centrally saved workbook which users can copy/paste from would probably be easier to manage.
Hello Mr. How are you? I want create a trial balance by using PIVOTBY or GROUPBY function with a calculated field for Balance (Debit-Credit). Need your help
Thanks but i dont want to share my macros with someone else and also i dont prefer to use macro for my own too because many times i have to share with collegaus
★ Get the example file ★
Sign up for our free Insiders program and get the example file:
exceloffthegrid.com/insiders
File Reference for this video: 0242 Function Library.zip
Outstanding! I have intended to develop this capability for quite some time, but couldn’t wrap my heads around how to do it. Your approach is clever. Thank you.
Thank Jim - Hopefully it's simple enough that you could build on it over time if you wish.
@@ExcelOffTheGrid It is, & I will. Now, I just need a similar vehicle for stock VBA code snippets!
Very smart move !! Exactly the infrastructure that cm lambdas need to become more popular and more tempting to use. Fantastic job !!!✌🏆
Thanks - I'm working on a full add-in that will have a lot more features, but I thinks this works well and is simple to implement.
It's worth noting that many people would like to pursue this for work they do on their Company Issued PC's... These days many companies are blocking the ability to create and store a Personal Macro Workbook under the guise of security. I know this, because my company did it. A work around is to save your personal Macros as an Excel Add-in and load it. That way you can still create one.
Using Excel Add-in is a better solution as many custom functions engineered with lambda can be workarounds for not using small VBA Macros in companies. I’m waiting with impatience Mark’s video to show us how to do it in a fast and furious way!
Yeah - the current VBA and security world is an absolute mess.
That is part of the reason why I showed all the code and provided a text file. Some users can run VBA, but can’t unblock downloaded VBA macros.
Good news is that the process is almost identical if using an add-in.
Thank you very much, Mark, for the useful and valuable content you are always providing to your followers 👍...
My pleasure! I’m just glad people find it useful. 😁
That makes it a lot easier to transfer custom functions between workbooks.😀
🙏❤️
Hopefully it's a simple way to do it so they are always available.
Thank you, Mark. This is a powerful addition to Excel and a great Christmas present for Excel users. Thanks again. Have a wonderful, peaceful Christmas.😀
Thanks, I’m glad you like it. 😁
holy smoke! Mark Proctor for President 🔥!
Thanks Carlos. I certainly would prefer to keep working with Excel, to being president. 😁
This is brilliant! I use my Personal workbook for VBA code I use often but hadn’t thought of this kind of usage..very clever
Now you can steal the concept and use it for lots of different things. 😁
First class approach Mark, thank you for sharing!
My pleasure! I hope you can put it to good use.
Outstanding video Mark!!
Thanks Chris - I appreciate that. 😁
Very good Mark 👌
Thanks! 😃
An interesting method. Thank you for sharing it, Mark.
You’re welcome.
Excellent idea to use and manage Lambda functions.
I was wondering, whether the same can be achieved using Office Scripts rather than VBA. There are several advantage using Off scripts e.g can be shared with colleagues, can work on excel online and also no need to save file in xlsm format.
The issue with Office Scripts is the lack of easy interface - i.e we can’t add a ribbon button.
But it would be possible. It would just need to be a parameterized script that contains all the LAMBDA code inside the script as text.
Maybe I will add that to the ideas log.
Great video, and a clever way of handling these custom functions.
I always have problem with my Personal Macro, it seems to want to open whenever I view an Excel spreadsheet in the Windows Explorer.
I gave up trying to view spreadsheets in Windows Explorer a long time ago, it was just to buggy. So, unfortunately, you might get the same issues with this.
Hi Mark, great video/idea as always! Was wondering though, what about saving a workbook (with the custom functions) as a template within XLSTART then rolling it out to colleagues to do the same? Cheers, Oliver
Using a template in XLSTART is a good option. The issue for distribution to many users is maintenance and updating. As different users will have different versions.
A centrally saved workbook which users can copy/paste from would probably be easier to manage.
Brilliant
Thanks 😁
Hello Mr. How are you? I want create a trial balance by using PIVOTBY or GROUPBY function with a calculated field for Balance (Debit-Credit). Need your help
Mark you are some kind of wizard
Thank - I’m glad you like it.
👍👍
Thanks but i dont want to share my macros with someone else and also i dont prefer to use macro for my own too because many times i have to share with collegaus
You're not sharing your macros with anybody. The macros stay on your PC. You are just sharing the custom functions by adding time into the workbook.