We help IT Professionals succeed at work.

No Overwrite on Excel Cells

Matt Pinkston
Matt Pinkston asked
on
I have an excel with a bunch of tabs several of which are just displays with formulas, how can I lock down the cells of the display only tabs so you can't overwrite cells.
Comment
Watch Question

Finance Analyst
Commented:
In the Format cells dialogue go to the Protection tab. Cells can be locked and/or hidden.

The protection only gets enforced once the sheet is then protected, Review tab, Protect sheet. A password is optional.
Martin Liss"There is still no cure for the common birthday." ~John Glenn
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
If there is VBA code involved in the tabs that you want to protect then put this in Workbook_Open,

Private Sub Workbook_Open()
Sheets("MySheet").Protect Password:="Secret", UserInterFaceOnly:=True
End Sub

Open in new window


What UserInterFaceOnly:=True means is that only the user interface is locked but code may still be run for that tab.