I am trying to run a macro that will add a line directly above th
button calling the macro but because the button doesn't actually sit i
a cell, it sits on the worksheet, it doesn't know where to add the lin
and so just adds it above the last selected cell, not above the button


I thought perhaps a hyperlink could call the macro but it doesn't see
to be able to. I have set up my hyperlink as follows:

=HYPERLINK("Add_New_Line()", "Add Next Line")

but when I click on the link it displays the error "cannot ope
specified file." (Add_New_Line() is my sub and Add Next Line is m
text.)

Any help would be much appreciated.

Thank

--
Message posted from http://www.ExcelForum.com