Is it possible to disable a hyperlink........
 

Is it possible to disable a hyperlink (greyed out) until all relevant data
has been imputed?
The hyperlink is only to sheets 2 but I want to set it up so that unless all
the fields are filled out correctly then they would not be able to move to
the next sheet.

Is it possible to disable a hyperlink........
 

Link the hyperlink back to itself.
Use the sheet FollowHyperlink event - check that the data is complete
and if so select the other sheet.
--
Jim Cone
Portland, Oregon USA




"iane46"
wrote in message
has been imputed?
The hyperlink is only to sheets 2 but I want to set it up so that unless all
the fields are filled out correctly then they would not be able to move to
the next sheet.