When you *lock* or protect the worksheet, you have the option to allow users
to select unlocked and locked cells. If you allow them to only select
unlocked cells, they may be able to see the results in the various cells, but
they will not be able to select these cells, and then see the formulae.

You can also freeze panes in such a way that the frozen part takes up the
entire screen , thus preventing any one from viewing anything but the range
from A1:O28. If you then strech the row heights and column widths slightly,
users will not even see row 29, or column P.

"Roger" wrote:

I have developed a model for people to use with several drop down menus. The
worksheet is locked except for variable info cells. All of the calculations
are done several rows below the usable worksheet and I am trying to lock the
screen to prevent people from scrolling down through the calculations.

Is it possible to lock the screen?