How do I activate the "greyed out" hyperlink function

C

crossroads

One of my workbooks has the hyperlink finction "greyed out", both from the
drop down from the Insert tab as well as right clicking on the email adresses
I'm trying to create hyperlinks to . The separate hyperlink button on the
task bar doesn't seem to work either. (I don't know if this problem is
connected with the fact that the workbook's File/Properties/Summary details
are also greyed out). My other workbooks' hyperlink functions are working
are all fine (and their File/Properties/Summary details are not greyed out).
I'm using Excel 2002 SP3.
 
D

Dave Peterson

Is the worksheet protected?
(Tools|Protection|Unprotect Sheet--you may need a password)

Is the workbook shared?
(Tools|Share workbook and unshare it)
 
C

crossroads

Dave - you're a saviour! Yes it was shared but not now - hyperlinks now
active. Thank you.
--
phil b
australia


Dave Peterson said:
Is the worksheet protected?
(Tools|Protection|Unprotect Sheet--you may need a password)

Is the workbook shared?
(Tools|Share workbook and unshare it)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top