Selasa, 24 Februari 2015

[ExcelVBA] Creating my first Excel add in


Hello all,

I was asked to work on a sheet that many users will have access to, that tracks projects. It is a download that someone found on the internet and it is pretty bad. I can do better than that. There are buttons at the top of the sheet that they have to sort a column by date, another column by file name, another to  sort a column by day.

My thought was to create some macros and use them. Then add the macros to a custom tab on the ribbon. But then I found out that macros do not travel with the file. So I thought can an add in be used to travel with the excel worksheet?

I do not want to install macros on a lot of computers to make it happen. I just want to send the file and it work.

Thank You all for any advice and help.

Jim Wagner


Posted by: Jim Wagner <>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: to enter the ezine, then search the ARCHIVES for EXCEL VBA.

Visit our ExcelVBA group home page for more info and support files:

More free tutorials and resources available at:




Tidak ada komentar:

Posting Komentar