vba code, command bar, command bar button, one button works but not two

**amazingg64** · 08-13-2012, 08:13 AM

Hi,

I have code that I've copy+pasted from another functioning workbook with new toolbar names, button names, etc. The problem is that one of the buttons (the second one) works fine, but the first one give me an error that says "Cannot run the macro "Document.xls'!GetWeeklyData'. The macro may not be available in this workbook or all macros may be disabled." Here's my code:

Please Login or Register  to view this content.

Both Subs are in the same document and all of the macros are enabled. The "SaveCopyAsCSV" Sub is in its own module as is the "GetWeeklyData" Sub. I can go into the sub and step through the "GetWeeklyData" Sub just fine and it runs, but when attached to the button, it doesn't. I don't understand why it wouldn't work just like the other one, so any help is greatly appreciated. Thanks!

**romperstomper** · 08-13-2012, 08:29 AM

Is the GetWeeklyData sub in a module called GetWeeklyData by any chance? Or have you perhaps misspelled the name?

**amazingg64** · 08-13-2012, 09:55 AM

Yes it is... Now that I renamed the sub to just GetData, it works just fine!

Thank you for catching that. Guess I need to get more creative with my naming.