Protecting Data in Excel

[Chris]

Hi world

Can anyone tell me if its possible to share access (on the same PC) to a
worksheet but ensure that once data has been entered into a field it can't
be deleted or altered without an administrator level access? If not
anyone have any ideas what a suitable alternative may be?


Many thanks

 

[Ken Wright]

Protection in Excel IMO should only ever really be considered as a means of
preventing unintended changes to data. There is no level of protection you can
set, where I couldn't gain access to any piece of data in whatever sheet you had
me work with. Same goes for pretty much all of the regulars in the group, and
also anyone that knows how to Google these groups.

If you are looking to prevent casual access, then just set the protection level
on those cells to 'locked' using Format / cells / Protection and then when done
Protect the sheet, as the cell protection status does nothing until the sheet
has been protected.