VBA code to disable A hyper-linked object dependent to a cell value

[Ansh_09]

Hi,

I need a help from u all. I would like to do that i have a rectangular object on excel sheet1 named "Calculate"and linked it to sheet2.
There are three cells A1,A2 and A3 on same sheet.
What would i like to do that if, there is no any text data in any 1 of a1, a2 and a3, then hyperlink gone disable and a popup message falshes to fill it first and if any 1 of these 3 cells has text it it show the sheet 2 when clicked.


Rgds
Anshu

[ragulduy]

Probably easier to do this with a button than an actual hyperlink, from the forms toolbar create a button and assign it to this macro:

Please Login or Register  to view this content.