excel vba-protect cells

  • Thread starter Thread starter chief
  • Start date Start date
C

chief

I tried to protect certain cells which have codes in them so that th
user only uses the drop down list in order to filter that informatio
into the other cells. My concern is that a user might enter info into
cell that has those =IF(....) codes in the cell, and will thereb
eliminate its use of the code. It doesn't seem to work though. Is ther
a way I can have it so that the VLOOKUP coded cell will be protecte
from outside manual input, yet still function when the user clicks o
an item from the dropdown list?

thank
 
Hi
just select the cells for which you want to allow entries and goto
'Format - Cells - Protection' and uncheck 'Locked'. Afterwards protect
your sheet
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA code and protected cells 9
Data Validation/Cell Protection Question 2
Protected Excel Worksheet 1
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Enabling Autofilter and Sorting in a Protected Sheet 2
Windows 7 Autofit row heights of merged cells in protected worksheet 0
Protecting cells with VBA (Excel 2003) 5
Protect Cells 2

Back
Top