View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default I require some assistance please

Hi Melissa,

you can apply protection to a worksheet to prevent changes to
formulae, layout etc (accidentally or deliberately), and this
protection can have a password (or not) to restrict it further. The
password can be easily broken by a determined hacker, but this does
not seem to be the case in your company from what you have described.

There are two aspects to it - cells themselves need to be locked for
the protection to apply to them, so highlight all the cells, click on
Format | Cells | Protection tab, and ensure that Locked is checked.

Then click on Tools | Protection | Protect Sheet. You will be
presented with some options, including whether to use a password or
not (write it down somewhere if you do).

Hope this helps.

Pete

On May 27, 8:01*pm, MelissaParkinson
wrote:
Okay....I figured out a simple way to do it, highlight two boxes and drag
down the amount of rows I need. *So that step is complete.

Here is another one for you. *How can I make tab 1 (workbook 1) the bosses
review page a "read only"? *Is that possbile?