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?

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?

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?

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?

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?

In the passing back and forth have you managed to saveas a Shared Workbook?

If so, many functions are not available.......inserthyperlink being one of
them

Also Protect sheet and Allow users to edit ranges will be unavailable.

Unshare the workbook and you will get your options back.

ReviewShare Workbook and remove the sharing.


Gord Dibben MS Excel MVP

On Thu, 3 Sep 2009 18:59:01 -0700, Gretchen
wrote:

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?