I have a worksheet with formulas. I have locked the appropriate fields that
I do not want users to mess with and unlocked the fields they can mess
with.....and then I protected the sheet. I wanted the user to enter data
using a simple form (from the Data menu)......but it's not letting me. Is
there a way around this? Or do I have to use the "vba form" stuff which I'm
not having a lot of luck with?

Thanks, in advance, for any helpful suggestions!
Paula

Works fine for me in XL 2003

"not letting me" means what to you? Error message? DataForm grayed out?

What is the layout of the unlocked cells?

Contiguous or not?

You can try this...........

Select the cells to be unlocked and InsertNameDefine

Name the range as "Database"(no quotes)

Select Database from the name box then formatcellsprotectionunlocked

Protect the sheet and try the dataform again.


Gord Dibben MS Excel MVP



On Thu, 3 Aug 2006 09:17:02 -0700, pmms wrote:

I have a worksheet with formulas. I have locked the appropriate fields that
I do not want users to mess with and unlocked the fields they can mess
with.....and then I protected the sheet. I wanted the user to enter data
using a simple form (from the Data menu)......but it's not letting me. Is
there a way around this? Or do I have to use the "vba form" stuff which I'm
not having a lot of luck with?

Thanks, in advance, for any helpful suggestions!
Paula

I'm using XL 2002.
Actually, I'm able to get the form to show but it won't allow me to enter
any new records. I've done what you suggested and still get the same result.
So, the dataform shows but "New", "Delete" and "Restore" are grayed out.
I'm able to scroll through the rows that are there but not enter new ones.

"Gord Dibben" wrote:

Works fine for me in XL 2003

"not letting me" means what to you? Error message? DataForm grayed out?

What is the layout of the unlocked cells?

Contiguous or not?

You can try this...........

Select the cells to be unlocked and InsertNameDefine

Name the range as "Database"(no quotes)

Select Database from the name box then formatcellsprotectionunlocked

Protect the sheet and try the dataform again.


Gord Dibben MS Excel MVP



On Thu, 3 Aug 2006 09:17:02 -0700, pmms wrote:

I have a worksheet with formulas. I have locked the appropriate fields that
I do not want users to mess with and unlocked the fields they can mess
with.....and then I protected the sheet. I wanted the user to enter data
using a simple form (from the Data menu)......but it's not letting me. Is
there a way around this? Or do I have to use the "vba form" stuff which I'm
not having a lot of luck with?

Thanks, in advance, for any helpful suggestions!
Paula

Apologies.

I was doing something different and it appeared to work, but not!

We'll have to keep looking.


Gord

On Thu, 3 Aug 2006 11:25:02 -0700, pmms wrote:

I'm using XL 2002.
Actually, I'm able to get the form to show but it won't allow me to enter
any new records. I've done what you suggested and still get the same result.
So, the dataform shows but "New", "Delete" and "Restore" are grayed out.
I'm able to scroll through the rows that are there but not enter new ones.

"Gord Dibben" wrote:

Works fine for me in XL 2003

"not letting me" means what to you? Error message? DataForm grayed out?

What is the layout of the unlocked cells?

Contiguous or not?

You can try this...........

Select the cells to be unlocked and InsertNameDefine

Name the range as "Database"(no quotes)

Select Database from the name box then formatcellsprotectionunlocked

Protect the sheet and try the dataform again.


Gord Dibben MS Excel MVP



On Thu, 3 Aug 2006 09:17:02 -0700, pmms wrote:

I have a worksheet with formulas. I have locked the appropriate fields that
I do not want users to mess with and unlocked the fields they can mess
with.....and then I protected the sheet. I wanted the user to enter data
using a simple form (from the Data menu)......but it's not letting me. Is
there a way around this? Or do I have to use the "vba form" stuff which I'm
not having a lot of luck with?

Thanks, in advance, for any helpful suggestions!
Paula

Thanks.

"Gord Dibben" wrote:

Apologies.

I was doing something different and it appeared to work, but not!

We'll have to keep looking.


Gord

On Thu, 3 Aug 2006 11:25:02 -0700, pmms wrote:

I'm using XL 2002.
Actually, I'm able to get the form to show but it won't allow me to enter
any new records. I've done what you suggested and still get the same result.
So, the dataform shows but "New", "Delete" and "Restore" are grayed out.
I'm able to scroll through the rows that are there but not enter new ones.

"Gord Dibben" wrote:

Works fine for me in XL 2003

"not letting me" means what to you? Error message? DataForm grayed out?

What is the layout of the unlocked cells?

Contiguous or not?

You can try this...........

Select the cells to be unlocked and InsertNameDefine

Name the range as "Database"(no quotes)

Select Database from the name box then formatcellsprotectionunlocked

Protect the sheet and try the dataform again.


Gord Dibben MS Excel MVP



On Thu, 3 Aug 2006 09:17:02 -0700, pmms wrote:

I have a worksheet with formulas. I have locked the appropriate fields that
I do not want users to mess with and unlocked the fields they can mess
with.....and then I protected the sheet. I wanted the user to enter data
using a simple form (from the Data menu)......but it's not letting me. Is
there a way around this? Or do I have to use the "vba form" stuff which I'm
not having a lot of luck with?

Thanks, in advance, for any helpful suggestions!
Paula