ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   other users cannot enter data into excel (https://www.excelbanter.com/excel-programming/374518-other-users-cannot-enter-data-into-excel.html)

Stacie

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??

Jim Thomlinson

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??


Tom Ogilvy

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??



All times are GMT +1. The time now is 03:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com