Getting macros to work in Excel 2010 .xlam Custom Ribbon

I have created an .xlsm file that I want to save as .xlam after I have it working properly.  I have simple macros in there that work just fine when run from the macro window (ALT+F8) or directly from the VBA Editor.  I added .xml code to create a custom ribbon with buttons to run the macros.  The ribbons and buttons show up fine, but I always get an error, "Wrong number of arguments or invalid property assignment."  I can immediately run the macros manually and they work just fine, so I guess there is something wrong with either the xml (I am quite the novice here on xml)  or there is a reference problem.  Any ideas?

Below is the xml I used for creating the custom ribbon/buttons and the xlsm file is attached
pmpExcelAddIns.xlsm
<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui">


  <ribbon>
    <tabs>
      <tab id="MyCustomTab" label="Case and Selections" insertAfterMso="TabHome">
				
  	  <group id="customGroup1" label="Adjust Case">
          <button id="customButton1" label="Lower" size="large" onAction="LowerCaseMacros" imageMso="LowerCase" />		
          <button id="customButton2" label="Upper" size="large" onAction="UpperCaseMacros" imageMso="UpperCase" />
          <button id="customButton3" label="Proper" size="large" onAction="ProperCaseMacros" imageMso="ProperCase" />
          <button id="customButton4" label="Sentence" size="large" onAction="SentenceCaseMacros" imageMso="SentenceCase" />
        </group>

        <group id="customGroup2" label="Decrease Selection">
          <button id="customButton5" label="Unselect current cell" size="large" onAction="UnSelectActiveCells" imageMso="SelectionPane" />
          <button id="customButton6" label="Unselect current area" size="large" onAction="UnSelectCurrentAreas" imageMso="_3DEffectsOnOffClassic" />
        </group>

      </tab>
    </tabs>
  </ribbon>

</customUI>

Open in new window

pmpataneAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

FamousMortimerCommented:
I think the problem may be in the <group id>.  you might need to specify insertAfterMso=...

Purely a guess as I found here.

http://rondebruin.nl/win/s2/win001.htm
0
pmpataneAuthor Commented:
Hi FamousMortimer,
The group id with the insertAfterMso= was because it was on an existing tab (the home tab) and it was code for where the group should go.  Thanks for checking, though!  (I did try it anyway and it made my Tab not appear at all.)
0
pmpataneAuthor Commented:
Found the answer!  I had Sub ProperCaseMacros() for macro name, s/b
Sub ProperCaseMacro(control As IRibbonControl)
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
pmpataneAuthor Commented:
I don't think I should gt the points, since I answered my own question, but the answer works and the question should be closed
0
pmpataneAuthor Commented:
Did more investigation and found the answer on a web site
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.