Excel 2010: Multiple spinners using same macro

I have a sheet with about 100 spinners for 100 different cells as part of a character sheet (I'm attempting to make a iPad friendly version). Anyway, I have one formula for setting the min/max for each cell and it's rather simple:

Please Login or Register  to view this content.

Works flawlessly on spinner 484. Now when I open the other spinners and assign them a macro and change it to Spinner_484, it does not work. The MAX is set to either 2 or 5 in the rest of the squares strangely enough, because they had no value before then. Any ideas what's happening?



And another thing, separate issue, in Excel 2010, if you open up multiple worksheet with macros and run a macro on one sheet, it f's up everything on your other sheet! Very upset about this, as Excel 2003 and earlier did not have this problem. I came back to my sheet and found all spinners displaced in a new spot, and when I tried to move them, they had a duplicate spinner directly below them that gave a vague error (the duplicate did) to having no macro assigned when I tried to increase/decrease it's value. I was hoping to use the top spinners which have individual macros assigned to each and every one of them, but they also got f'd up by this "bug" in Excel and I'd either have to "Assign" and code a separate macro, again, to each and every spinner, or just assign a single macro to all spinners since it does the same thing (hence the first part of my question).


One final thing. When working with vba and I go back to my main worksheet, there is no longer any cells displayed on the left hand side where defined "names" and cell blocks usually show up. I have to hit cntl-F2 twice to get them to show up. Any ideas why this is happening in Excel 2010? Never had any of these issues before using old Excel.

Okay, it seems each spinner has a unique ID like it does in Visual Basic .net, i.e. Spinner_484 is it's own item, however in vba in Excel under it's properties and in vba, its name is not listed whatsoever.

I found this out by deleting all spinners but the one that worked, then I copied that one spinner to all 100-cells, then in Format Control, Cell Link, I assigned the proper cell to each spinner. Then I went to change the max value of the spinner and it was still stuck at '1'. I was perplexed, so I changed my code above to Sub Spinner001_Change(), and Set 0Spinner to "Spinner 001" and got the following error:

Run-time error 'lots of numbers ()'
The item with the specified name wasn't found.

So obviously, the code won't work because its looking for the physical spinner 001, which is completely bogus because Excel does not list the spinner id's anywhere . Is there another way to use the code to set the max value of the spinner being used to the fluctuating value it needs to be so I don't have to recycle the same code for each and every physical spinner?

You're a gentleman and a scholar! That worked! Such a simple code. I'll mark this as solved, but I do have a question:

So, "application.caller" works with any event that calls a macro if the object is assigned one in Excel?