how to allow other users to make changes for some perticular cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hello
in my office we are trying to figure out how to allow other users to make
changes and save changes only for some perticular cells.
if we share the work book, any user can change anything and any cell in the
whole workbook. but we dont want to do that. we just want to allow all users
to save some perticular cells.
plz help me to solve this problem
i will highly appreaciate it

Thanks
 
Hi,

If you protect the workbook first, then share it, you should be able
to do what you are looking for.

In XL2003, select Tools|Protection|Allow Users To Edit Ranges

Then share your workbook.


HTH,
JP
 
Hi
I tried it but didnt work.
it lets change any cell/column/row
i want to give access to other users to change some certain cells.
plz help me

thanks
 
Back
Top