Macro to randomize and delete accessed hyperlinks

Hi

I am struggling for coding a macro. Can anybody please help?

I have 8 hyperlinks in a column in a work sheet. Taking input from the user, this set (8 hyperlinks) has to be copied n times (n - the user input ). Then each set (contaning 8 limks) has to be randomized locally (within each set). So there will be a total of n times randomization. Then as the user accesses the hyperlink, that specific hyperlink has to be deleted from the worksheet so that the user is not able to access that hyperlink further. This is to be applicable to all 8*n hyperlinks.

Thanks a lot.

Twinkle