View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] aaminof@yahoo.com is offline
external usenet poster
 
Posts: 1
Default Removing the constant link from Spinner

Hello,

I in Excel, i created a spinner from the Forms menu.

That spinner points to say cell a100, while the spinner itself is in
cell a1.

When i copy the spinner accross to cell b1..q1 the link in the spinner
remains pointing to cell a100.

How can i change that link so that when i copy the spinner accross the
columns, the link will change accordingly.
Thanks.