Temperamental Macro's: Errors occur if any changes are made

This is driving me mad.

I have a series of Macro's which, thanks to some help from this forum, were working perfectly.

An example:

Please Login or Register  to view this content.

The Macro checks that at least one check-box in a range has been ticked, and returns an error if that is not the case.
However. If I attempt to replicate this Macro but for a different range of check-boxes, by copying the code into a new module and changing the numbers, I.e

Please Login or Register  to view this content.

To

Please Login or Register  to view this content.

I suddenly am getting an error message(s):

Unable to get the value property of the checkbox class.
OR
method checkboxes of object _worksheet failed

What has changed!?

I have a feeling there is something going on around where my macro's are saved and stored. But it doesn't work even if the module is hosted in my Personal.xls file.

I would really appreciate it if somebody could shed light on this for me. This place is becoming like my second home...

Originally Posted by Norie

Are the checkboxes all of the same type?

Interesting point - but none of them have =EMBED (or whatever it is for ActiveX) - So I think they're all Form control

Originally Posted by romperstomper

Are you sure you haven't grouped any controls?

Hello again,

I'm unsure what you mean? However, I have grouped all the check-boxes so that if one moves the others move and they all stay together, like you would want in a user/client form.

Is this a big no-no?

It wouldn't be a massive deal if there was an alternate way to make sure the boxes don't get moved around?

Ultimately I want people to be able to check or uncheck the boxes, but not move around or resize - if there was another way to do this, I wouldn't mind at all about not grouping them.