Macro to unhide row with hyperlink

[pezalmendra]

Hello!

Im trying to use an hyperlink to run a macro that after that unhides a row from a table.
The idea is that each time I click the hyperlink, the macro runs, unhides the next row and copy again in the cell bellow they hyperlink to run again that macro.

I have tried it but can only do it for one chance cause when it copies down the hyperlink it doesnt work no more... I have attached the file so that you can better have a look to what Im looking for.

Thanks for the help!

Regards,New Line.zip

[mrice]

Try adding an extra line to reset the target of the hyperlink.

Please Login or Register  to view this content.

[pezalmendra]

Thanks!! It works good, but just one only thing more I forgot to say:

I want this code to work only in rows 8 till 17.
Another hyperlink with the same macro will run from rows 18 till 27.
Etc...

Thanks again, regards

pezalmendra

[mrice]

Try

Please Login or Register  to view this content.

[pezalmendra]

Brilliant!

Thanks

[Cutter]

Hello pezalmendra, and welcome to the forum.

If you are satisfied with the solution(s) provided, please remember to mark your thread as Solved.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save