problems with sheet protection

I've tried numerous times to lock the formula cells in my restaurant's daily
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/13127-problems-with-sheet-protection.html
sales & labor workbook. It has a sheet for each week of the month and a
monthly summary sheet. The net sales and labor from the weekly sheets carry
into the monthly summary sheet.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13127

I have locked the formula cells in the monthly summary sheet and protected
the sheet, no problem. However, when trying to lock the formula cells in the
weekly sheets, there are 2 cells that keep locking which I don't want to lock
and am not selecting. The data in these cells do not carry into the monthly
summary page.

I have protected plenty of Excel workbooks/sheets before, and never had this
problem.

Any suggestions?

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!

On Wed, 12 Jul 2006 1502 -0700, homeyworld
wrote:

Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13127
>I've tried numerous times to lock the formula cells in my restaurant's daily
>sales & labor workbook. It has a sheet for each week of the month and a
>monthly summary sheet. The net sales and labor from the weekly sheets carry
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13127
>into the monthly summary sheet.

Please repost this Excel question in an Excel newsgroup. Scroll down
the list of subject areas on the webpage and find a suitable Excel
group; this is the first alphabetically, but it has to do with a
different program, Microsoft Access.

John W. Vinson[MVP]

Duh! Thank you!

"John Vinson" wrote:

> On Wed, 12 Jul 2006 1502 -0700, homeyworld
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13127
> wrote:
>
> >I've tried numerous times to lock the formula cells in my restaurant's daily
> >sales & labor workbook. It has a sheet for each week of the month and a
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13127
> >monthly summary sheet. The net sales and labor from the weekly sheets carry
> >into the monthly summary sheet.
>
> Please repost this Excel question in an Excel newsgroup. Scroll down
> the list of subject areas on the webpage and find a suitable Excel
> group; this is the first alphabetically, but it has to do with a
> different program, Microsoft Access.
>
> John W. Vinson[MVP]
>