Simple Macro works in 1 Excel file but not the other.

Hello,

A few weeks ago I asked a question about Assigning a Macro to a button using VBA in this thread here http://www.excelforum.com/excel-prog...fic-shape.html (hopefully the link works. Don't know how to link back without copying the link on top and pasting). The code worked great in one file but when I paste it in another file and change it to the appropriate names, it doesn't even get past the first line of Code. Anybody know why this is?

Please Login or Register  to view this content.

Any advice would be appreciated. Thanks.

~BBS

The link worked fine

Did you check teh sheet names in both your file and inthe macro - do they match?

Hi there,
Is there a 'TestSrch' shape/button in the new file ?

If you get a subscript error, then there is no sheet in the activeworkbook named "Srch", or no button named "TestSrch"). There is no other possibility.

Accessing a collection with the name of a member is not case-sensitive:

worksheets("sheet1") is the same as worksheets("SHEET1")

shapes("bob") is the same as shapes("BOB")

Text comparisons, however, are, by default, case-sensitive: "Bob" <> "bob"

I think I figured it out. The object was grouped with a bunch of other objects. When I ungrouped them, it still didn't work but for some reason, the group of objects that are now ungroup have their assigned macros. Will be testing if the rest do work. I'll mark this as solved if ungrouping the objects makes the macro work.

Edit:

Yep, definitely worked. Thanks for the education and help, especially with the lack of sensitivity of Caps vs Small letters. Very much appreciated.

You're welcome.