Learn Excel – UDF in a Personal Macro Workbook? Podcast #1385

April 18, 2011 at 2:50 pm

In a previous Learn Excel from MrExcel Podcast [Episode #1375] Bill created a UDF [User Defined Function] as an Excel Macro to Concatenate or ‘Join’ Text. Lon liked the User Defined Function that Bill was using and decided to make use of it himself. However, upon attempting to move the UDF Macro to his PERSONAL.XLSB Excel Workbook, Lon discovered that the Excel Macro would no longer work. “?” What happened?

Today, in Episode #1385, Bill shows us two (2) workarounds that address and correct this issue and create a Personal Excel Add-in in the process! Follow along! It’s easy and fun to do!

"Learn Excel 97-2007 from MrExcel" by Bill Jelen…This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

"Microsoft Excel 2010: In Depth" by Bill JelenFor more Excel 2010 knowledge, check out “Excel 2010 In Depth“, by Bill Jelen a.k.a. MrExcel.

“The Learn Excel from MrExcel Podcast Series”

MrExcel.com — Your One Stop for Excel Tips and Solutions.


Entry filed under: Excel 2007, Excel 2010, Excel 2010 In Depth, Learn Excel 97-2007, Learn Excel from MrExcel, MrExcel Podcast, MrExcel Products. Tags: , , , , , , , , , , , , , , , , , , , , , , , , , , , , .

Dueling Excel – Dynamic OFFSET or INDEX?: Podcast #1384 Learn Excel – VBA Picture Comments: Podcast #1386

Learn Excel from MrExcel

Learn Excel Podcast Splash Screen

The Excel Beginners Book:

"Don't Fear The Spreadsheet" - by Tyler Nash, Bill Jelen, Tom Urtis and Kevin Jones

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 742 other followers

Live Lessons Excel 2010 DVD

"Live Lessons Excel 2010" DVD

RSS MrExcel Recent Articles

  • An error has occurred; the feed is probably down. Try again later.

Recent MrExcel Tweets

MrExcel Podcast Archive

%d bloggers like this: