How do I activate the "greyed out" hyperlink function

G

Guest

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)
 
G

Guest

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)
Click to expand...
 

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

Similar Threads

How do you turn Hyperlink on if it's greyed out? 1
hyperlink greyed out 1
How do I UNSHARE an Excel Workbook 2
How do you automatically hyperlink an email address? 1
how do I get my Data tab to work? It is completely greyed out. 1
Meeting Importance and Sensitivity greyed out 1
How do I display the full file path for a hyperlink in Office 2003 6
How do I delete a macro in Excel 2003? Button is greyed out. 3

Top