Thread: How do I put a formula into an unlocked cell on protected workshee
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ukredskin ukredskin is offline
external usenet poster
  
Posts: 4
Default How do I put a formula into an unlocked cell on protected workshee
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.
Reply With QuoteReply With Quote