MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Cell Protection

  Asked By: Francisca    Date: Nov 01    Category: MS Office    Views: 858

I need a help from you, i have a shared workbook, now i cant run
macros on it and cannot password protect it. can you tell me a way by
which in a shared workbook/worksheet, i can

1. prevent anyone from entering data onto my spreadsheet/s
2.password protect my worksheet if possible.

actually there is a workbook with multiple users/worksheets, and it is
shared and i am looking at it from a data protection point of view so
that no one can go into others sheet and delete/edit any data.



1 Answer Found

Answer #1    Answered By: Jakson Williams     Answered On: Nov 01

You will have to un-share the workbook  to add/change/remove protection  on any
sheet. There are many things that cannot be done while a workbook is shared. See
the Excel Help topic "Features that are unavailable in shared workbooks".

I believe you need to:
1. Unshare the workbook. This deletes the change history also (again, see
Excel's Help topics).
2. protect  sheets with passwords as desired. The protection and passwords
cannot be changed once you share the workbook again.
3. Any macros you want to run in the shared workbook must exist in it before
it is shared, and must not use features that are unavailable in shared workbooks
(such as creating new pivot tables).
4. Reshare the workbook.

Didn't find what you were looking for? Find more on Cell Protection Or get search suggestion and latest updates.