I am trying to create a month-to-month family budget plan and i will like to
have the ability to prevent other househole users from doing any changes to
some of the coded cells on the work sheet. is there a way to do so and how?

Use cell locking. When you protect the sheet, use a password. See:
http://www.officearticles.com/excel/...soft_excel.htm
*******************
~Anne Troy

www.OfficeArticles.com



"Colin2u" wrote in message
...
I am trying to create a month-to-month family budget plan and i will like
to
have the ability to prevent other househole users from doing any changes
to
some of the coded cells on the work sheet. is there a way to do so and
how?

I di try that that but the funny thing is that after doing so and restart the
excel program the protected cell(s) was still able to be change

"Anne Troy" wrote:

Use cell locking. When you protect the sheet, use a password. See:
http://www.officearticles.com/excel/...soft_excel.htm
*******************
~Anne Troy

www.OfficeArticles.com



"Colin2u" wrote in message
...
I am trying to create a month-to-month family budget plan and i will like
to
have the ability to prevent other househole users from doing any changes
to
some of the coded cells on the work sheet. is there a way to do so and
how?

Did you:

Unprotect sheet
Select cell(s)
Format (menu)
Cells
Protectection
Locked (selected or checked)
Protect sheet
--
steveB

Remove "AYN" from email to respond
"Colin2u" wrote in message
...
I di try that that but the funny thing is that after doing so and restart
the
excel program the protected cell(s) was still able to be change

"Anne Troy" wrote:

Use cell locking. When you protect the sheet, use a password. See:
http://www.officearticles.com/excel/...soft_excel.htm
*******************
~Anne Troy

www.OfficeArticles.com



"Colin2u" wrote in message
...
I am trying to create a month-to-month family budget plan and i will
like
to
have the ability to prevent other househole users from doing any
changes
to
some of the coded cells on the work sheet. is there a way to do so and
how?

ha ha ha

"Colin2u" wrote:

I am trying to create a month-to-month family budget plan and i will like to
have the ability to prevent other househole users from doing any changes to
some of the coded cells on the work sheet. is there a way to do so and how?

In a home environment password protection has a decent chance
of protecting the workbook. Especially if there is project level
protection.
(unless the kids are really set to "break the bank").

--
steveB

Remove "AYN" from email to respond
"KJ" wrote in message
...
ha ha ha

"Colin2u" wrote:

I am trying to create a month-to-month family budget plan and i will like
to
have the ability to prevent other househole users from doing any changes
to
some of the coded cells on the work sheet. is there a way to do so and
how?