I want to create a simple set of macros that I can pass around as an AddIn. When I run it as a Macro in my workbook it’s fine. It doesn’t work as an AddIn.

The AddIn creates a menu item under the AddIns worksheet menu. When I try to call the function from the menu item, I see this error.

"Cannot run the macro FOO. The macro may not be available in this workbook or all macros may be disabled."

All macros are enabled but I can’t figure out how to make the functions from the AddIn show up in either the Macros list or in the AddIn menu I created.

More to come…

Update March 26, 2013, 1:17 PM

I’m making progress. It looks like there might be a name space collision between the AddIns default workbook “ThisWorkbook” and the active documents workbook name “ThisWorkbook.”

I renamed the AddIn Workbook and references that when I called the AddIn function from the AddIn menu and I was able to call the method (AddInName.FOO).


Great site for picking website color schemes

Nice pleasing color palette
I have a hard time with colors. I don’t know if I’m actually color blind but I will admit that from time to time I’ve left the house with two different color socks. I know my inability to ascertain color can hamper my ability to create visually pleasing web sites but I don’t want to stick to black and white. However, finding color designs to steal (ahem, borrow) is extremely tedious.

However, for those who are also color scheme challenged, choosing a great eye pleasing color palette is made easier with the COLORlovers website. COLOURlovers is a community driven website which provides color palettes which you can use for your website. The content is nicely laid out, and if you have a palette theme in mind (tans, blues, etc) you can drill down into dozens of different pallettes.

The next time you are looking for a great color palette take a look at COLOURlovers.