I only have two worksheets in the workbook and they are not both selected at
the same time.

"Gord Dibben" wrote:

I would suggest you have more than one worksheet selected.


Gord Dibben MS Excel MVP

On Thu, 3 Sep 2009 16:32:01 -0700, Gretchen
wrote:

Thank you. I did as you suggested but the box was already checked. So I
unchecked then rechecked it, saved and closed the workbook then re-opened the
workbook. Unfortunately, I still can't hyperlink those e-mail addresses.
Any other suggestions?

"Sheikh Saadi" wrote:

Go to Tools -- AutoCorrect Options -- 'AutoFormat As You Type' tab --
check the check box corresponding to the 'Internet and network path for
hyperlinks' option.

Hope this helps... If yes, plz click YES button...
--
Sheikh Saadi


"Gretchen" wrote:

Two of us have been working on a workbook and passing it back and forth
between us for revisions, etc. Neither one of us knowingly protected it.
Now, new e-mail addresses won't hyperlink although we could do so previously.
The INSERT toolbar, where the hyperlink button lives, is all greyed out with
the exception of Header/Footer. On the REVIEW toolbar, the 'protect sheet',
'protect workbook', and 'allow uer to edit range' are all greyed out.
How do I fix this?