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:

Sub Spinner484_Change()

Dim oSpinner As Shape
Set oSpinner = ActiveSheet.Shapes("Spinner 484")
oSpinner.ControlFormat.Max = [aw210]
oSpinner.ControlFormat.Min = 0

End Sub
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.