Sort problem

I have created a spread sheet which contains several columns and rows of 
data. One of the columns contains a button with a URL. Clicking on this 
button allows me to go to a web site associated with the data in that row. 
If I perform a sort on a  column I have found that the button does not 
follow the row that is was originally in. Is there a way to sort the data 
and buttons while maintaining the integerity of the file?? Thank you. 

Bob:
> If I perform a sort on a  column I have found that the button does not 
> follow the row that is was originally in.

Sort operates on the content of the Cells to be sorted.
The Button is a Form Control and has no relation to cell contents, and no 
relation to any Cell other than to indicate its position. (Internally, 
naturally, it may refer to Cells.)

Most often, folk would not want a Sort to move a Form Control.

Of course, you can have a Cell hold a hyperlink.
That Cell will be affected by a Sort.
-- 
Good wishes!
Roy Lewis
C_Tech volunteer
(UK)

Thank you Roy. I created a new column which now contains named hyperlinks 
and the sort goes well. However a new "problem" has surfaced, i.e. by
using 
the button scenario I was able to click on it and a new page would appear in 
my browser but with the hyperlink scenario any existing web page will now be 
overwritten, which I would rather not have occur. Is there a way to prevent 
this from occurring?.


"lemoto" <ctech@corel.ca> wrote in message 
news:VA.00004ad0.003f5f15@corel.ca...
>
> Bob:
>> If I perform a sort on a  column I have found that the button does not
>> follow the row that is was originally in.
>
> Sort operates on the content of the Cells to be sorted.
> The Button is a Form Control and has no relation to cell contents, and no
> relation to any Cell other than to indicate its position. (Internally,
> naturally, it may refer to Cells.)
>
> Most often, folk would not want a Sort to move a Form Control.
>
> Of course, you can have a Cell hold a hyperlink.
> That Cell will be affected by a Sort.
> -- 
> Good wishes!
> Roy Lewis
> C_Tech volunteer
> (UK)
>
> 

Bob:
> by using 
> the button scenario I was able to click on it and a new page would appear
in 
> my browser but with the hyperlink scenario any existing web page will now
be 
> overwritten, which I would rather not have occur.

I guess you are using Internet Explorer.

The action taken by the browser when a new URL is specified is usually 
determined in Options/Preferences/similar in the browser.

I find that when I use a Button with a URL link a new IE instance occurs each 
time.
Using a Cell hyperlink, I see a new Tab in Opera each time.
Opera is set to open a new Tab each time.

Firefox can be similarly set.
-- 
Good wishes!
Roy Lewis
C_Tech volunteer
(UK)

To be clear: my default browser is Opera.
-- 
Good wishes!
Roy Lewis
C_Tech volunteer
(UK)