| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
other users cannot enter data into excel
I have created some forms where I have locked the cells that I do not want to
be changed but left the ones for the user's data unlocked so user's can change data and insert files. It works fine on my end but when I send it over to the other user it won't work. They don't even have the option to unprotect the sheet because that option is greyed out. (I did not put a password on it). When they click on insert, all insert file options are greyed out..... Any idea what is causing this?? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
other users cannot enter data into excel
Is this a shared workbook. If so that could cause the problems you are
describing... -- HTH... Jim Thomlinson "Stacie" wrote: I have created some forms where I have locked the cells that I do not want to be changed but left the ones for the user's data unlocked so user's can change data and insert files. It works fine on my end but when I send it over to the other user it won't work. They don't even have the option to unprotect the sheet because that option is greyed out. (I did not put a password on it). When they click on insert, all insert file options are greyed out..... Any idea what is causing this?? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
other users cannot enter data into excel
are you using xl2002 or later and they are using xl2000 or earlier? -- Regards, Tom Ogilvy "Stacie" wrote: I have created some forms where I have locked the cells that I do not want to be changed but left the ones for the user's data unlocked so user's can change data and insert files. It works fine on my end but when I send it over to the other user it won't work. They don't even have the option to unprotect the sheet because that option is greyed out. (I did not put a password on it). When they click on insert, all insert file options are greyed out..... Any idea what is causing this?? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| users must enter value = or than a certain value | Excel Worksheet Functions | |||
| how do i force users to first enter data in one cell before anythi | Excel Discussion (Misc queries) | |||
| Only allow users to enter new data | Excel Programming | |||
| Defining specific areas for users to enter data | Excel Discussion (Misc queries) | |||
| Not allowing users to enter data into certain cells if another cell is empty | Excel Programming | |||
Linear Mode
