Relative references for form controls

[blomquist]

Hi

Is there a way to copy cells that contain form controls so that the references become relative? I have removed the dollar-sign from the cell link field but that doesn't help. The new cells and form controls (spin buttons) get the same reference as the copied form control. Do I really have to go through all my 100 spin buttons and set the correct references?

I'm using Excel 2007.

Thanks in advance.

/Thomas

 

[Andrew Poulsom]

Welcome to MrExcel.

Sorry, no. The reference is just a string.

 

[blomquist]

Welcome to MrExcel.

Sorry, no. The reference is just a string.

Thanks. That's strange. It's gonna be a long night

/Thomas