Vera has attended:
PowerPoint Intermediate Advanced course
Excel Intermediate course
Workbook protection
How can I protect a sheet from certain people so they don't delete any formulas they shouldn't? Eg: if many people need to add information on a document that I've created but they keep deleting or changing formulas where they shouldn't.
RE: Workbook protection
Hi Vera,
Thank you for the forum question.
Select all cells, where you want someone to do changes. Right click on your selection and click Format Cells. Click the Protection tab (the last one). Remove the tick from Locked. Click the Review tab and click Protect sheet.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
