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?
|