I'm not sure if this is possible, but basically what I'm trying to do is
protect a worksheet but still allow the users to click on the locked cells to
see a formula.

I've got that to work ok, but I want to know, is it possible for them to
also see the cells that are referenced in this formula through outlining and
color? To see that you normally have to double-click the equation, but when
the worksheet is protected and the cell is locked it won't let you get to
that point.

I don't want users to be able to change anything in the cell, just be able
to see the formula and the outlining and colors of any referenced cells in
said formula. Thanks.

Not possible.

The colors and outlining of the cell references only show when the cell is in
editing mode.

It is protected and cannot be edited so no show.


Gord Dibben MS Excel MVP

On Wed, 22 Aug 2007 09:16:00 -0700, Bruce
wrote:

I'm not sure if this is possible, but basically what I'm trying to do is
protect a worksheet but still allow the users to click on the locked cells to
see a formula.

I've got that to work ok, but I want to know, is it possible for them to
also see the cells that are referenced in this formula through outlining and
color? To see that you normally have to double-click the equation, but when
the worksheet is protected and the cell is locked it won't let you get to
that point.

I don't want users to be able to change anything in the cell, just be able
to see the formula and the outlining and colors of any referenced cells in
said formula. Thanks.