Recently, someone asked me if there was a better way to manage add-ins in Excel 2007. Specifically, he wants something better than Office Menu – Excel Options – Addins – (wait) – Go. Here’s a recent edition to my Personal.xls
Dim wb As Workbook
‘Dialog won’t show if there’s no workbook showing
If ActiveWorkbook Is Nothing Then
Set wb = Workbooks.Add
‘Show addin dialog
‘Close wb if it was created
On Error Resume Next
And here’s how I added it to my QAT (Quick Access Toolbar). Click on the little down-arrow next to the QAT and choose More Commands…
Visit PTS Installing an Add-in in Excel 2007 for more on Add-ins.
Visit Ron de Bruin’s How do I create a PERSONAL.xls(B)… page for more on Personal.xls.