Hi

I have a workbook of 13 sheets. The first sheet is an entry page where
information is entered across the year. It isn't protected as people
need to have access to it to make their entries.

The other 12 sheets are one for each month of the year. They fill up
month by month as entries are made on sheet 1. They hold summaries of
the information entered on the first page. People don't need direct
access to them.

Here's the problem. If I protect sheets 2-13 , then when I enter
information on sheet 1 I get an access error saying that they cannot be
overwritten .

However , as nobody need to have direct access to the information on
these pages , I would rather protect them.

Is it possible to update these sheets when I'm sending data from sheet
one , but still have the sheets protected so that the data and coding
etc. cannot be overwritten by accessing them via the tabs?

Hope you can help.


Best Wishes


Drno