How do you protect a sheets or cells or columns in a workbook, instead of the whole workbook?

Minty5490

New Member
Joined
Jul 13, 2016
Messages
13
Hi,

I have a few sheets in a workbook, which have macro`s, formula`s. When someone wants to input information they can do in the main sheets, where there are no formula`s, only input information.

How can I lock or password protect the sheet or stop keying in the sheet, protecting the cells?

thanks :)
 

Some videos you may like

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
40,956
Office Version
365
Platform
Windows
Select the sheet you want to protect & on the Review tab select "Protect Sheet"
 

JoeMo

MrExcel MVP
Joined
May 26, 2009
Messages
16,851
Office Version
2010
Platform
Windows
You can password protect the few sheets so that a user cannot make entries or change/delete formulas. But, if the user really never needs to see those sheets, it may be easier to make then very hidden. Here's how:
1. select the sheet.
2. right-click the sheet's tab (where the sheet name is) and select 'View code'. This will open the VB Editor window (VBE).
3. Press the F4 key - this opens the sheet's 'Properties' menu on the left side of the VBE.
4. Scroll down the properties menu to 'Visible' and in the drop down immediately to the right select 2-xlSheetVeryHidden.
5. save the file and close the VBE.

Unlike a hidden sheet, a veryHidden sheet cannot be found on the Ribbon menus (such as View>UnHide) which would allow a user to unhide the sheet. If you are concerned that a user might access the VBE/Properties to unhide the sheet, then you can password protect the VBE Project - VBE Menu>Tools>VBAProject Properties>Protection.
 

Watch MrExcel Video

Forum statistics

Threads
1,099,583
Messages
5,469,523
Members
406,656
Latest member
Kriscrawford76

This Week's Hot Topics

Top