Thank You Bob. Q2 Dealt With.

On QI . I have already done that but was hoping to restrict the viewing in a
more direct way. Thanks for your help

Stew

"Bob Phillips" wrote:

Q1

You could grey out all of the cells other that the information area. You
would need to manage the changing of that area, adding/removing information,
which can be done using conditional formatting (as long as the are in
question is not huge).

Q2

Excel 2003 has a facility to colour code the tabs, right-click on the tab
and select Tab Color ... from the menu.

--
__________________________________
HTH

Bob

"stew" wrote in message
...
Hi all

1st Question

Can I limit the visual area that can be viewed only to the area which has
information on a worksheet

2nd Question

can the tabs at the bottom showing the names of worksheets be colour coded
i.e. Data entry and read only different colours

Thank You for looking

Stew