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

[Minty5490]

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

 

[Fluff]

Select the sheet you want to protect & on the Review tab select "Protect Sheet"

 

[JoeMo]

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.