when you protect a sheet, you can't enter using a form

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? Data>Form grayed out?

What is the layout of the unlocked cells?

Contiguous or not?

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

Select the cells to be unlocked and Insert>Name>Define

Name the range as "Database"(no quotes)

Select Database from the name box then format>cells>protection>unlocked

Protect the sheet and try the dataform again.


Gord Dibben MS Excel MVP



On Thu, 3 Aug 2006 09:17:02 -0700, pmms <[email protected]> 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? Data>Form grayed out?
>
> What is the layout of the unlocked cells?
>
> Contiguous or not?
>
> You can try this...........
>
> Select the cells to be unlocked and Insert>Name>Define
>
> Name the range as "Database"(no quotes)
>
> Select Database from the name box then format>cells>protection>unlocked
>
> Protect the sheet and try the dataform again.
>
>
> Gord Dibben MS Excel MVP
>
>
>
> On Thu, 3 Aug 2006 09:17:02 -0700, pmms <[email protected]> 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 <[email protected]> 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? Data>Form grayed out?
>>
>> What is the layout of the unlocked cells?
>>
>> Contiguous or not?
>>
>> You can try this...........
>>
>> Select the cells to be unlocked and Insert>Name>Define
>>
>> Name the range as "Database"(no quotes)
>>
>> Select Database from the name box then format>cells>protection>unlocked
>>
>> Protect the sheet and try the dataform again.
>>
>>
>> Gord Dibben MS Excel MVP
>>
>>
>>
>> On Thu, 3 Aug 2006 09:17:02 -0700, pmms <[email protected]> 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 <[email protected]> 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? Data>Form grayed out?
> >>
> >> What is the layout of the unlocked cells?
> >>
> >> Contiguous or not?
> >>
> >> You can try this...........
> >>
> >> Select the cells to be unlocked and Insert>Name>Define
> >>
> >> Name the range as "Database"(no quotes)
> >>
> >> Select Database from the name box then format>cells>protection>unlocked
> >>
> >> Protect the sheet and try the dataform again.
> >>
> >>
> >> Gord Dibben MS Excel MVP
> >>
> >>
> >>
> >> On Thu, 3 Aug 2006 09:17:02 -0700, pmms <[email protected]> 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
> >>
> >>
>
>