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


--
twinklejmj
------------------------------------------------------------------------
twinklejmj's Profile: http://www.excelforum.com/member.php...o&userid=27085
View this thread: http://www.excelforum.com/showthread...hreadid=468708