You should be able to adapt this spiel from John Walkenbach to deal
with this issue.
http://j-walk.com/ss/excel/tips/tip44.htm
HTH
Paul
--------------------------------------------------------------------------------------------------------------
Be advised to back up your WorkBook before attempting to make changes.
--------------------------------------------------------------------------------------------------------------
I really dislike the check boxes from the Control toolbar. The one on the
Forms toolbar is so much easier to implement. But there are times when I
want them to move and size with cells (like when I hide unused rows). So I
end up spending hours implementing dozens of identical check boxes.
Right now I have 26 that all call identical macros. It appears that I can't
have them all call the same macro, but that I must have 26 separate macros.
Is it possible for them all to call just one?
I am using Excel 97. One of my problems with using a check box from the
Control toolbar is the focus stays on the control. This is not good. So the
macro each calls runs:
Application.ScreenUpdating = False
Range(ActiveCell.Address).Select
Am I missing something here? Is there a simpler way to do this?
Don <donwiss at panix.com.