How do I put a formula into an unlocked cell on protected workshee

U

ukredskin

As soon as I protect a worksheet the function button on the toolbar is greyed
out. I can still type the formula into an unprotected cell manually, but
can't select a formula from the greyed out Function button on the toolbar.
Why does the function button become unavailable as soon as I protect the
sheet? This did not happen in the past.
 
M

Mike H

Hi,

Most odd. I've tried to replicate this in E2003, E2007 & E2010 and I can't.

Can you let us know the Excel version your using?

Clarify what you mean by 'unprotected cell'. For example do you mean an
'Unlocked' cell on a protected sheet?

Is the workbook protected?

Is it shared?
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
 

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

I can still select & manipulate locked & protected cells in '07 1
filter for unlocked cells in protected Excell 2007 sheet 0
How was user able to (accidentally) change an unlocked cell to loc 1
How can I stop format change when copying data into unlocked cells 1
Compressing multiple functions across an array into one cell 6
How do I insert a comment in unlocked cell of a protected workshee 2
Insert/ delete row in protected worksheet 6
Pasting a cell into bookmarked table from excel vba 1

Top