-1

Sometimes ago I faced with the following problem: I have protected Worksheets and formulas in cells. So, I haven't opportunity to view formulas in formulas Bar(with lighting). Thereby, does it really to allow users view formulas in formulas bar if Worksheet protected.

pnuts
  • 58,317
  • 11
  • 87
  • 139
Chrome63
  • 1
  • 1

1 Answers1

0

Two conditions are required:

  1. When formatting the cells leave the Hidden property uncheck in the Protection tab (see fig. 1)

enter image description here

  1. When protecting the worksheet check the Select locked cells property (see fig. 2)

enter image description here

EEM
  • 6,601
  • 2
  • 18
  • 33